How to get different tallys from same query based on date range

[Guest]

This seems like a very simply task, but I can't figure it out. I have a
table that covers data for the whole year. I have a query that tally's one
field of student's status (i.e. graduated, failed, voluntarily left, never
showed up, etc). Now I want a report that will break that down by quarter.
I tried creating 4 different queries for each quarter but when I tried to
create a report referencing all more than one of the queries, I get error
"you have chosen fields from record sources which the wizard can't connect".
When I tried to create a single query with multiple date "where criterias",
that (obviously) didn't work either. Should I be using my query that tally's
the whole year and then use formulas in my report to break the quarters down?
If so, I'll need some help on that. Can someone point me in the right
direction? Thanks in advance. Thx, Dj

 

[Nikos Yannacopoulos]

It's simpler than that really... use a query that tallies by date, and
start making a report on it using the report wizard; when you get to the
step where you add Grouping levels, group on the date field, and click
on the Grouping Options button to select grouping by quarter. Just
follow through the wizard and it's done the job for you!

HTH,
Nikos

 

[Guest]

That worked. Thanks so much!!!