Cumulative values - deducting the previous value

[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

 

[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

 

[Per]

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 alsohttp://www.utteraccess.com

Thank you!

Per