Monthly format

  • Thread starter Thread starter Chi
  • Start date Start date
C

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
 
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
 
Thank you so much !! I got it. It works perfectly.

Chi

Marshall Barton said:
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.....
 
Back
Top