cumuative query

E

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.
 
M

[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
(e-mail address removed)
www.fmsinc.com/consulting
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need a Query that shows cumulative totals 4
2 dimensional date sort 2
Identify closed/finalized records the month they were opened Acces 2
Get a Count of Columns with a value 0
Time Calculations 3
Complex Count Query 0
Combine 2 Charts 2007 Excel 1
Like to start using Access 1

Top