dianemarie
Instructor
Hello, I have a report that has invoice information (from an Invoice table) on the detail line, with one group (by Vendor). Invoices go against POs (there is a separate PO table), and the report has to show total amount of POs, total of all invoices (by vendor) and the amount remaining against ALL of the POs for that vendor. I am having trouble getting the total amount of the POs. It is adding the PO total for each invoice. Example: If Vendor A has 2 POs for $5,000 each, but has three invoices (two against PO1 and one against PO2) then the total amount of PO says 15,000. I am a Crystal report developer and in Crystal I would use what we call a Running Total in an instance like this. However, I can't figure out how to do this in Access. Do I accomplish it in the query or the report? Any help would be greatly appreciated. Thank you.
