Order By Date in Access SQL [Resolved]

[ober0330]

SELECT *
FROM [Cell Equipment Complete]
WHERE ((([Cell Equipment Complete].DATE_DUE) Between #1/1/2004# And #1/31/2004#))
ORDER BY [Cell Equipment Complete].DATE_DUE;

I'm trying to order entries by their date but Access doesn't want to do it on a report. I can do it if I just run the query, but when I go to use a report with the same query, it doesn't put them in date order.