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:
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.
Last edited by gvee; 09-12-07 at 15:28.
Reason: Re-formatted table.