Hi,
I'm trying to get the totals for any given number of months and years and show the total as 1 row.

Hopefully I can explain a little better later in my post

I have the date stored as a date ie. 3/1/1999

For example:
3/1/1999: 4
3/5/1999: 5

12/1/2000: 4
12/4/2000: 5

What I would like to do is let the user choose a date range (Month and Year) and show them the totals by month.

So the results would be:

Date Amount
March 1999: 9
December 2000: 9

Can anyone help me with this. I know it would be easier to add the month and year fields to the table, but I really don't want to do that if I don't have to.

The goal is to display this in a datareport.

Please help.

Thanks,
JazzBass