I enter months in my database when i print they are out of order

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

Guest

I'm entering months in my database Jan-Dec but when i print my report jan-dec
do not be in correct order how can i get my records to show in correct order
Herman Jones
 
Herman said:
I'm entering months in my database Jan-Dec but when i print my report
jan-dec do not be in correct order how can i get my records to show
in correct order Herman Jones
Click to expand...

If by "correct order" you mean chronological order then you need to use DateTime
fields formatted to display as mmm. Access has no way of knowing that the
strings you enter into Text fields are "months". They are just words and that
is how they will be sorted.

You could also add an addtional numeric field where you enter the numbers 1 to
12 and use that field for sorting.
 
Back
Top