Running totals in detail line

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a problem.

I am working on a report that list orders and material requirements. The
report breaks by part number. For each part number there can be multiple
orders. One of the fields in my reports links to the inventory database. This
database lists the part number and the current balance remaining.

In the report, I may have multiple order numbers for a particular part. The
field headings and data should look something like this:

Part number Beg Bal Order # Order date Curr Req
Balance
123 1,000
12345 1/1/2007
100 900
23456 2/1/2007
150 750
45678 3/1/2007
100 650
257 600
32345 1/1/2007
200 400
44456 5/1/2007
300 100
55678 6/1/2007
400 -300

This is how it should look. I am having a problem creating a running sum for
the transaction details. Do you have any ideas on this. A variation on this
report would be to produce a sub-report that list only those orders that
result in a negative balance - but that is for another day.
 
Andre7266 said:
I am working on a report that list orders and material requirements. The
report breaks by part number. For each part number there can be multiple
orders. One of the fields in my reports links to the inventory database. This
database lists the part number and the current balance remaining.

In the report, I may have multiple order numbers for a particular part. The
field headings and data should look something like this:

Part number Beg Bal Order # Order date Curr Req Balance
123 1,000 12345 1/1/2007 100 900
23456 2/1/2007 150 750
45678 3/1/2007 100 650
257 600 32345 1/1/2007 200 400
44456 5/1/2007 300 100
55678 6/1/2007 400 -300
Click to expand...

Add a hidden text box (named txtRunReq) to the detail
section. Set its control source to the Curr Req field and
set its RunningSum property to Over Group

Then the Balance text box can use the expression:
=[Beg Bal] - txtRunReq
 
Back
Top