Running totals in detail line

A

Andre7266

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.
 
M

Marshall Barton

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top