Cumulative values - deducting the previous value


P

Per

I have a problem regarding financial data, the data is cumulative in
each year ie. the second quarter data is the sum of quarter 1 and 2,
the third quarter is the sum of quarter 2 and 3 and so on. I have so
far used dlookup for each field in order to deduct the previous
quarters value however it is not a very flexible approach and it it
quite tedious to make the same changes to all fields. Is there a
faster and better way?

Thanks
 
Ad

Advertisements

J

John W. Vinson

I have a problem regarding financial data, the data is cumulative in
each year ie. the second quarter data is the sum of quarter 1 and 2,
the third quarter is the sum of quarter 2 and 3 and so on. I have so
far used dlookup for each field in order to deduct the previous
quarters value however it is not a very flexible approach and it it
quite tedious to make the same changes to all fields. Is there a
faster and better way?

Thanks

Yes. Don't store the derived data AT ALL; instead use a Totals query or DSum()
to sum up the actual values over a span of time.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com
 
Ad

Advertisements


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

Top