Custom Sort on months...

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
I would think you'd put something like the following in your SORT box...

= Format ([SomeDateField], "mm")


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.

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

= Format ([SomeDateField], "mm")


Rick B


Access rookie said:
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.
Click to expand...
Click to expand...
 
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




Access rookie said:
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.

Rick B said:
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
Click to expand...
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.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top