Date sort not working?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I built a monthly report, based on a query, that returns records if the date (short format) falls within a specified month. On the query, I have the dates sorted in ascending order and on the report's sorting and grouping, I have the dates set to sort in ascending order. However, when I view the report, the dates are all out of order.

Does anyone have any suggestions as to what I am doing wrong?

Thanks,
Carrie
 
Are you formatting the date field in the query? You comment regarding (short
format) suggests this. I recommend to never format any fields within a
query.

--
Duane Hookom
MS Access MVP


Carrie said:
Hello,

I built a monthly report, based on a query, that returns records if the
Click to expand...
date (short format) falls within a specified month. On the query, I have
the dates sorted in ascending order and on the report's sorting and
grouping, I have the dates set to sort in ascending order. However, when I
view the report, the dates are all out of order.
 
Back
Top