J
julostarr
I'm using Access 2003. I have been entering orders with dates, but in order
to have the orders separated by month for a report I added a field in my
table that displays just the month that the order is to be shipped. I
created this with a numeric value at the beginning to make it easier to enter
the data, but it also displays the month name along with it so it will
display on the report that way. For example:
1 - JAN
2 - FEB
The problem is that now it sorts the numbers in the wrong order in both my
report and quiery. Like this...
1 - JAN
10 - OCT
11 - NOV
12 - DEC
2 - FEB
How can I fix this?
to have the orders separated by month for a report I added a field in my
table that displays just the month that the order is to be shipped. I
created this with a numeric value at the beginning to make it easier to enter
the data, but it also displays the month name along with it so it will
display on the report that way. For example:
1 - JAN
2 - FEB
The problem is that now it sorts the numbers in the wrong order in both my
report and quiery. Like this...
1 - JAN
10 - OCT
11 - NOV
12 - DEC
2 - FEB
How can I fix this?