Access 2007 - Problem sorting within a report

Status
Not open for further replies.

Luerker

Beta member
Messages
2
I will try to be a descriptive as I can. I am trying to make a report that would sort dates by month regardless of year. I can sort by month but it considers the year too. For example, it lists all the dates in January-December in 1998 but then starts over by listing dates in January 1999. How can I make it so it groups all of one month's dates regardless of year? I can clarify if I am unclear. Thanks in advance.
 
create a new column as text. enter the month for each row.

might be too much work

copy the table into excel, copy the column, in another column write a formula to display only the month
 
I'm not that familiar with Access, but just using t-sql you would create a temp column in the query that just uses datepart(m, date) as Month and then sort on that column.
 
Status
Not open for further replies.
Back
Top Bottom