I have report of Boats sold by vendors and private sellers. Report fields are'Boat Name', 'Type', 'Private Seller?' (which is a 'Yes/No' data type), 'Price (exc.VAT)'.
Sellers are grouped together in 'Sellers' table, and identified by 'Private Seller?' field as a "Yes/No" data type.

I wish to insert at foot of Report"Boats for Sale by Private Sellers"...."£nnnnnn""Boats for Sale by Vendors"............"£nnnnnn"

I can get these (sub-)totals in two separate queries {Private Seller?, Criteria "Yes", (and Criteria"No"), then Price (exc.VAT), Sum} but adding the SQL code into a text box in the Report footer brings up syntax errors.
How can I get these results as sub-totals in my Report footer?

Use subReports to separate Vendors, or Grouping levels

Thanks , Rich! Right on the button.
By the way, how do you Young Citizens get to be so smart?
Thanks again, Neil.:p

Originally posted by Neil_395

By the way, how do you Young Citizens get to be so smart?

Born like it I guess. :o