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?