quarterly finances

[striker73]

I have a table with sales information in it, for example:

Customer_ID Date Amount
1 1/1/00 $1452.00
1 2/1/00 $3521.00

I am trying to create a query that will return something like the following:

Quarter Amount
1 'Sum of months 1-3
2 'Sum of months 4-6
3 'Sum of months 7-9
4 'Sum of months 10-12

Can someone please help me set up my query or at least get me started in the right direction? Thanks so much!!

 

[Databaseguy]

Use the datepart() function

Dim MyDate As Date	
Dim Msg	
MyDate = Now()
Msg = "Quarter: " & DatePart("q", MyDate)
MsgBox Msg