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

H

Herman Jones

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
 
R

Rick Brandt

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top