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

On Thu, 26 Aug 2010 07:02:13 -0700 (PDT), Per <(E-Mail Removed)>
wrote:

>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/For...-US/accessdev/
http://social.answers.microsoft.com/.../en-US/addbuz/
and see also http://www.utteraccess.com

On Aug 26, 5:57*pm, John W. Vinson
<jvinson@STOP_SPAM.WysardOfInfo.com> wrote:
> On Thu, 26 Aug 2010 07:02:13 -0700 (PDT), Per <per.alexanders...@gmail.com>
> wrote:
>
> >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/For...-US/accessdev/
> *http://social.answers.microsoft.com/.../en-US/addbuz/
> *and see alsohttp://www.utteraccess.com

Thank you!

Per