Is there any trick in getting the MNTH to run from Jan – Dec vs. alphabetically?

[djclntn]

I’ve believe to have really gotten the handle on manipulating the “DATE” fld to represent other formats in queries.


Now that I’m successfully able to run my monthly queries by taking the DATE “TDATE” & formatting it in a query by: MNTH: Format([TDATE], “mmm”) I even fiqured out how to have my “MNTH” run from Jan to Dec, M: Format([TDATE], “m”) & just hide column (or check off the grid box I the query design. Now I come upon anther quandary --- let me illustrate:

I have a query with the months, projectID, sumofhrs, sumofbilling, etc.
- MNTH (no longer in Date/Time frmt)
- ProjectID
- SumOfHRS
- SumOf…etc.

Now. If I want to see a query with just the months sums – the ProjectID I just yank out the “ProjectID out from the query – very simple. Except my “MNTH” are in alphabetically order when I want them to run from Jan – Dec. Is there any trick in getting the MNTH to run from Jan – Dec vs. alphabetically?

[orange]

How come MNTH is now a string?
Create a table ...tblMonths
tblMonths
MnthName MnthOrder id
Jan 1 1
Feb 2 2
Mar 3 3
Apr 4 4
May 5 5
Jun 6 6
Jul 7 7
Aug 8 8
Sep 9 9
Oct 10 10
Nov 11 11
Dec 12 12

Use this table in your query. Join your current MNTH fld to MnthName.
Select MnthOrder in the query, order your query on MnthOrder.

[Amicron]

Another method... just use Month(TDATE) and that will give you the numeric month of the date field. Sort your query by this field.

[djclntn]

Thanks, that worked really well!