S
Sheila D
Hi
I have a table which contains invoice information and a query which extracts
by Client in Descending date order - what I would like to do is calculate
either in the query or a report the difference from 1 invoice to the next.
Can't find a way to do it - is it possible or do I have to export to Excel
and do it there? This is what I am looking for where Col 3 is calculated from
values in current/previous record in Col. 2
Date Amount Increase/Decrease from last invoice
07/04/2004 3085 2585
27/02/2003 500 -750
22/02/2002 1250 0
10/01/2002 1250 1025
20/11/2001 225 -1025
10/10/2001 1250 0
26/09/2001 1250 -1250
19/09/2001 2500 2275
23/07/2001 225 -368.75
20/07/2001 593.75 -593.75
20/07/2001 1187.5 912.5
27/11/2000 275 -350
21/06/2000 625 175
17/11/1999 450
Any help much appreciated
Sheila
I have a table which contains invoice information and a query which extracts
by Client in Descending date order - what I would like to do is calculate
either in the query or a report the difference from 1 invoice to the next.
Can't find a way to do it - is it possible or do I have to export to Excel
and do it there? This is what I am looking for where Col 3 is calculated from
values in current/previous record in Col. 2
Date Amount Increase/Decrease from last invoice
07/04/2004 3085 2585
27/02/2003 500 -750
22/02/2002 1250 0
10/01/2002 1250 1025
20/11/2001 225 -1025
10/10/2001 1250 0
26/09/2001 1250 -1250
19/09/2001 2500 2275
23/07/2001 225 -368.75
20/07/2001 593.75 -593.75
20/07/2001 1187.5 912.5
27/11/2000 275 -350
21/06/2000 625 175
17/11/1999 450
Any help much appreciated
Sheila