Quarterly Reports


G

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
 
Ad

Advertisements

G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top