Using previous record to perform calculation

  • Thread starter Thread starter Ali
  • Start date Start date
A

Ali

Here's my query:

CONum PONum POTotal COTotal RevTotal
1 18 $855
$12,500 -$11,645
2 18 -$11,645 $30,000
-$41,645

and so on...

I want to know how I can copy the previous record value of RevTotal to
POTotal to subtract COTotal and keep this going. This is really simple
but I'm having hell of a time getting this right.

Any help would be appreciated.
 
could you generate a report based on this query with a group header for
PONum

create an unbound field for RevTotal in the details for each roll then sum
the revTotal in the PONum footer
 
Problem is I'm creating this for a report. I need to make a report for
each CONum. The CONum "2" Report has to show the balance left over
from CONum 1. The reports have to be done a specific format also. So
all the CONum record has to be displayed.
 
Back
Top