Sorting by Month

[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.

 

[Duane Hookom]

You can include both the number and the month name in your report. Sort by
the numeric and display the month name.

 

[Guest]

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





.

 

[Nhu-Nguyet Nguyen]

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.