cumuative query

[Ed Lillis]

I have a query shown below:
Date OpenedItems
Feb '05 45
March '05 21

I want to make it read:
Date OpenedItems Cum
Feb '05 45 45
Mar '05 21 66

The original table has 45 items with different Feb dates, but I only want
to show by month.

 

[[MVP] S.Clark]

Using a Crosstab query, you should be able to accomplish this.

--
Steve Clark, Access MVP
FMS, Inc.
Call us for all of your Access Development Needs!
1-888-220-6234
[email protected]
www.fmsinc.com/consulting