[Luerker]

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.

[office politics]

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

[Luerker]

The tables have to stay as they are so I cannot edit them.

[bla!!]

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.