monthly and yearly report?

[athos07]

i have a very simple problem, but since im new to this i dont know what to put in my sql code..

i have a table called [masterlist]

biddate itbnumber ac
02/02/2001 ITB2-011-04 ov-10
08/28/2001 ITB2-011-04 uh-1h
12/10/2001 ITB2-039-06 f-27
01/10/2002 ITB2-039-06 uh-1h
01/13/2002 ITB2-039-06 uh-1h
01/15/2002 ITB2-039-06 ov-10

i want to have have the monthly and a seperate yearly report for this. when requested for a monthly or yearly report.

 

[bdmclennan]

Hi,

MONTHLY
-------
SELECT Format([biddate],"mm-yyyy&quot AS MONTH, masterlist.itbnumber, masterlist.[ac]
FROM masterlist
GROUP BY Format([biddate],"mm-yyyy&quot, masterlist.itbnumber, masterlist.[ac];

YEARLY
-------
SELECT Format([biddate],"yyyy&quot AS Years, masterlist.itbnumber, masterlist.[ac]
FROM masterlist
GROUP BY Format([biddate],"yyyy&quot, masterlist.itbnumber, masterlist.[ac];

You can add in your counts/avg/min/max etc to these queries.

Hope this helps

B.