Monthly format

[Chi]

Hi,

My report information is grouped by month. I would like to have the months
listed like this "January, February, March, April........December".

If I use Ascending option, the list will stat form A to Z Or

If I use Descending option, the list will star form Z to A.

Thanks

Chi

 

[Chi]

Thank you Marshall Barton,
Your information is very useful! I followed your ideas and the month names
are displayed in my report!!! However, the month "February" goes first
instead of January.

Ex: February, January, March..... I would like the month name are list
correctly like January, February, March, April, May.....

Thanks
Chi

 

[Chi]

Thank you so much !! I got it. It works perfectly.

Chi

Assuming everything else is squared away, that will happen
if the February entry is in an earlier year than the January
entry.

Or maybe you still have some Text vs Date confusion?
--
Marsh
MVP [MS Access]

Your information is very useful! I followed your ideas and the month names
are displayed in my report!!! However, the month "February" goes first
instead of January.

Ex: February, January, March..... I would like the month name are list
correctly like January, February, March, April, May.....