How do I organize dates in Access reports?

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

Guest

I have created a report (Report Wizard) with expiration dates, and they are
organized alphabetically. How do I get them in chronological order instead?
 
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
 
Back
Top