In any given Month 2

[brendoaccess]

Hi. I have a 2 field table with Donation_Amount and Donation_Date. There are thousands of records covering over 15 years. I want to be able to tell which the frequency of donations by month - regardless of the year - and can't think how.

What I want is something like

>December and <February

or

=January

in a criteria field to give me all the donations for January for all the records. Then I can sum, avg, or whatever.

Many thanks

 

[fneily]

Have you looked at Pivot Tables?
Or in your query, create another field using DatePart. Then run your criteria off of that. eg.
MonthPartatePart("m",[Yourdatefieldname])

 

[Remou]

You can use Month:

Select Month(Donation_Date), Sum(Donation_Amount)
From tblDonations
Where Month(Donation_Date) Between 5 And 8
Group By Month(Donation_Date)

 

[brendoaccess]

Brilliant - very helpful from both of you.

Many thanks.