How do I group a report by month and ignore the year?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have generated a report that groups my data based on month; however, I want
just 12 headings (Jan through Dec) and have all of our clients fall under one
of the months based on effective date regardless of the year they became
clients. Please advise. I am not a high level Access user, so please give
me a non-SQL solution.

Thanks!
 
In the query behind your report, you probably still have a field that
indicates the Dtae(and Year) that a customer signed up.
Create a calculated field in your query grid... ex. DateSignedUp
MonthSigned : Month(DateSignedUp)
So... a query with just these fields CustomerName, MonthSigned would be
able to be grouped by Month, and if some beacme a customer in Jan of 02, or
03, or 06, they'll fall under the JAN group.
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
 
Back
Top