Quarterly Reports

[Guest]

I need some advice on how to do a query that leads up to a quarterly report.
I have an unbound form for generating reports where the user selects a start
date and a stop date as well as the type of report they want. If their report
selection is the quarterly one, these dates could be three, six, nine, or
twelve months apart. Once the report and dates have been selected I don't
know how to get the query to 1.) count up the number of items in just a three
month period and 2.) how to seperate out the four or three or two or one
three month periods so the report can display them in various "columns". As I
write this I realize this might be too much for a discussion group, so, if
anyone knows of a good article or link, or example I will be happy to read
through that and ask specific questions later. Thanks in advance for your
help.
Cheers,
Michael

 

[Guest]

Hi,

This simple query...

SELECT test.dated, Format([dated],"q") AS QUARTER
FROM test
GROUP BY test.dated, Format([dated],"q");

looks at ALL dates in the table, and calculates the quarter for each.

Hope this helps,
geebee