Cumulative values - deducting the previous value

  • Thread starter Thread starter Per
  • Start date Start date
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
 
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
Click to expand...

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
 
Back
Top