I'm enterind months in database when printing not in order

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

Guest

I'm enter dated in my database by month like Jan-Dec but when i print my
report the month are not in order April may come before January THE DATA FOR
THE MONTH IS CORRECT BUT NOT IN CORRECT ORDER.
 
You used a Text field, instead of a Date/Time field.

Consequently, Access sorts the values as text instead of dates.
 
Back
Top