Sorting by Month

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

I have a report based on a query. One of the fields in
the query is "Month" (Jan, Feb, etc.). I have two colums
in the underlying lookup table; one for Primary key which
is numerical 1 through 12. The second column is Jan
through Dec respectively. I use the numerical Primary key
because that is the only way I could get the column to
list Jan - Dec. Without the Access automatically sorting
the list alphabetical. So when I build a report the month
will group 1-12 ok if I use the Primary key in the query
(which is meaningless as a visual re4ference to the
month). But when I use the related field "Month" Access
forces a sort A-Z and my report starts with Apr instead
of Jan. How do I solve this?

Thank you in advance for your service.
 
You can include both the number and the month name in your report. Sort by
the numeric and display the month name.
 
Thanks, got it!
-----Original Message-----
You can include both the number and the month name in your report. Sort by
the numeric and display the month name.

--
Duane Hookom
MS Access MVP





.
Click to expand...
 
Duane Hookom said:
You can include both the number and the month name in your report. Sort by
the numeric and display the month name.

--
Duane Hookom
MS Access MVP




Give me call about it, than I'll send you the directions.
Click to expand...
 
Back
Top