How do I organize dates in Access reports?

E

eaudryn

I have created a report (Report Wizard) with expiration dates, and they are
organized alphabetically. How do I get them in chronological order instead?
 
G

Greg

Eaudryn,

If the dates are in a 'date/time' format, you can go to the area of the
report you wish sorted (most likely detail) right click in that area and
select 'Sorting and Grouping. and choose the date field and sort order.
Most likely you are just sorting off of another column. The other
possibility is that your date is not truly a datetime format and is sorting
like a text field with October following January.

Hope this helps.......

Greg
 
Top