The main report has the consignor information and the subreport shows the detail for each item they had for sale.
The description field is call DESC and it will have various thing entered in it....Collected, Uncollected, Commission, Classic, Fee, Miscellaneous.
I need to get a separate grand total for all the items that the description is (Collected, Commission, Classic, Fee and Miscellaneous). Then those totals need to be in the main form. The field name for the amounts in the subreport is AMOUNT. So I end up with a grand total for Collected, a grand total for Commission etc. on the main report for each consignor.
This is the output of the subreport.
Item # Price Description Amount <--- (heading)
1 1000.00 Collected 1000.00
(dup hidden) (dup hidden) Commission 500.00
(dup hidden) (dup hidden) Fee 275.00
10 2000.00 Collected 1000.00
(dup hidden) (dup hidden) Commission 500.00
(dup hidden) (dup hidden) Fee 275.00
Main Report (at end for the Consignor)
Collected 2000.00
Commission 1000.00
Fee 500.00
Each consignor has a separate report.
Can anyone help...?