Monthly format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chi - 07 Apr 2008 16:16 GMT

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

Reply to this Message

Marshall Barton - 07 Apr 2008 17:17 GMT

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

You need to group on the month number, not the month name.

Is the month name in a Text field in your table? It should
be a Date field. A date field can be grouped by month just
by setting the interval to month and a date field can
display the month name simply by using a text box's Format
property of mmmm

Signature

Marsh
MVP [MS Access]

Reply to this Message

Chi - 07 Apr 2008 18:15 GMT

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

> >My report information is grouped by month. I would like to have the months
> >listed like this "January, February, March, April........December".
[quoted text clipped - 10 lines]
> display the month name simply by using a text box's Format
> property of mmmm

Reply to this Message

Marshall Barton - 07 Apr 2008 19:42 GMT

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?

Signature

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
[quoted text clipped - 17 lines]
>> >
>> >If I use Descending option, the list will star form Z to A.

Reply to this Message

Chi - 08 Apr 2008 16:37 GMT

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
[quoted text clipped - 22 lines]
> >> >
> >> >If I use Descending option, the list will star form Z to A.

Reply to this Message