I have a subdatasheet in a form. It is for parts used on an invoice.
Qty PN Desc Unit cost Amount Discount Total
Amount is = [Qty]*[Unit Cost]
Total is = [Amount]*[Discount]
There may be 5 or so parts that are used on an invoice.
So there would be 5 values in the total column.
How do I get the sum of these totals no matter how many rows there are?
Any help would be greatly appreciated...