Access Help

[Guest]

How do I get the months to list chronologically instead of alphabetically in
my reports? The lookup table has them listed chronologically.

 

[Dean]

Does the table contain actual dates or text fields listing the names of the
months?

 

[George Nicholson]

If your Month value is based on the value in a "Months" lookup table, add a
field to that table called MonthSortOrder and fill with numbers 1 to 12.
Include MonthSortOrder in the query used for your report. Use MonthSortOrder
rather than Month when setting the Order of your report .

or

If your Month value is based on a date field, add a field to the query used
for your report: MonthSortOrder:=Month([MyDate]). Use MonthSortOrder rather
than Month when setting the Order of your report .

HTH,

 

[Guest]

You are going to need another column in your lookup table. This column should
be numerical. Integer or even Byte would be fine. In it place the numerical
equivent like Jan = 1, Feb = 2, etc. Then include this field in all queries
and reports that need to sort on the month.