query help!!

[striker73]

I have a table with entries like the following:

Date Amount Custimer_ID
------- ------- -----------
1/1/00 $4000.00 1
2/1/00 $6000.00 1
3/1/00 $2300.00 1
4/1/00 $8000.00 1
etc.

I want to create a query that contains the following:

Customer_ID Date SumOfAmount
------------ ------------- -----------
1 1/1/00-6/1/00 $18,000.00
2 1/1/00-6/1/00 $22,000.00
3 1/1/00-6/1/00 $12,000.00


Will someone please help me create this query? I can get it so it lists each month in that range, but not the sum. Any ideas? Thanks!!!

 

[striker73]

Nevermind, I figured it out. I needed to select "Where" in the Total row for Date, instead of Group By. Thanks anyway though!