Format field issue in a Select Query

  • Thread starter Thread starter SilviBeOS
  • Start date Start date
S

SilviBeOS

Greetings to all

I am running Access97.

In a Select Query based on a Table, I have created the following format
field:

Date: Format([Order]![OrderDate],"yyyy mmmm")

In the Total Row, I have selected the option: GroupBy

Running the query displays the following results:

2003 August
2003 July
2003 September

QUESTION
How can I change/modify the query (or even add criteria) so as to have it
display the results in the usual sequence of months:

2003 July
2003 August
2203 September

Any tips/help from a Sherlock Holmes in disguise would be appreciated.

Sylvie
 
I am replying to my own post. I have found the answer to my problem. So
here goes:

In a Select Query, I created the following 2 fields:

Calendar: Format([Order]![OrderDate],"yyyy mmmm") (show)

DateSerial(Year([OrderDate],Month([OrderDate]),1) (do not show)

Total Row: GroupBy (both fields)

And got the results I was looking for. Voilà! Hope this helps other Access
newbies.

Sylvie
 
Back
Top