Grouping Question

  • Thread starter Thread starter Paul Murphy via AccessMonster.com
  • Start date Start date
P

Paul Murphy via AccessMonster.com

Hi Folks,

Quick Question...
I have a text field in a table called 'Month' which can only be 'Jan',
'Feb', 'Mar' etc to 'Dec' It is controlled by a combo box.

When I run a report, it automatically groups the Months alphabetically,
which is not what i want. Does anyone know how I could get it to group by
Jan, Feb, Mar etc, in that order ie in month order.

Thanks in advance,
Paul
 
Paul said:
Hi Folks,

Quick Question...
I have a text field in a table called 'Month' which can only be 'Jan',
'Feb', 'Mar' etc to 'Dec' It is controlled by a combo box.

When I run a report, it automatically groups the Months alphabetically,
which is not what i want. Does anyone know how I could get it to group by
Jan, Feb, Mar etc, in that order ie in month order.

Thanks in advance,
Paul
Click to expand...

If your table also contains a column of type Date/Time, you could use
GROUP BY Month(MyColumn)

Try this:
GROUP BY Month(MyMonthColumn & " 1 2005")

Where 'MyMonthColumn' is your column (text field) named 'Month' (which you should, of course, not name is, as Month is a function in Access VBA)

Hth
PerL
 
Back
Top