Sum Past three months Revenue

[north19701]

I have a query where I need a calculated field to total 3 months worth of revenue by vendor. For example:

Month Vendor Revenue
12/31/2004 - Jackson - $100.00
1/31/2004 - Jackson - $100.00
2/29/2004 - Jackson - $100.00
3/31/2004 - Jackson - $100.00
4/30/2004 - Jackson - $100.00
12/31/2004 - Murray - $100.00
1/31/2004 - Murray - $100.00
2/29/2004 - Murray - $100.00
3/31/2004 - Murray - $100.00
4/30/2004 - Murray- $100.00

I need to set up a calculated field in the query that will sum vendor totals, in this case from 2/2004 to 4/2004. Of course next month this will change to 3/2004 to 5/2004. Can anyone help with this?

 

[blueshark]

Looks like that works good. I guess ctr # is the same as vendor. The example I sent before doesn't seem work that good. I thought I had it. Tried it again and got garbage. Too late in the day to figure out why.

That's one good thing about posting; everyone has a different technique. Using DSum in that way may be quite helpful as I do a lot of rolling average type of stuff. Typically I'll code it out but now you've given me a good way to get at stuff quicker.

thanks

I'm from Newark. St. Mark's and UD.

 

[north19701]

well cool, glad I could help. DSUM seemed to work best for me.
I live in Bear now, right below newark, came from Elkton in cecil county (don't hold it against me... )

 

[blueshark]

Was ctr # the same as vendor? That's the one part I haven't gotten to work.

","[Ctr #] = " & [Ctr #] & " AND

 

[north19701]

yeah, vendor in my example is Ctr # in my table.