Custom Sort on months...

[Guest]

Hello,
I have a report that opens up information sorted by month. The problem is I
would like it to sort by month...eg Jan, Feb, March, etc. not by alphabetical
order. I can't remember whether I sorted this during the wizard and don't
know how to get back.
Is there a way to sort this information by month occurence and not by
alphabetical order?

Thanks,

John.

 

[Rick B]

I would think you'd put something like the following in your SORT box...

= Format ([SomeDateField], "mm")


Rick B

 

[Guest]

Hey Rick,

Thanks for your reply; dumb question, but where's the sort box? In the
report menu somewhere, or in the underlying query?

John.

I would think you'd put something like the following in your SORT box...

= Format ([SomeDateField], "mm")


Rick B

Hello,
I have a report that opens up information sorted by month. The problem is I
would like it to sort by month...eg Jan, Feb, March, etc. not by alphabetical
order. I can't remember whether I sorted this during the wizard and don't
know how to get back.
Is there a way to sort this information by month occurence and not by
alphabetical order?

Thanks,

John.

 

[Rick B]

In the report design view, there is a sorting and grouping icon in the menu.
It looks like a blue square bracket with two smaller blue square brackets
inside that one ant then two small equal signs (that are supposed to
represent lines on the report).

Rick B

Hey Rick,

Thanks for your reply; dumb question, but where's the sort box? In the
report menu somewhere, or in the underlying query?

John.

I would think you'd put something like the following in your SORT box...

= Format ([SomeDateField], "mm")


Rick B

Hello,
I have a report that opens up information sorted by month. The problem

is
I

would like it to sort by month...eg Jan, Feb, March, etc. not by alphabetical
order. I can't remember whether I sorted this during the wizard and don't
know how to get back.
Is there a way to sort this information by month occurence and not by
alphabetical order?

Thanks,

John.