I am working on a subreport with shows the data from a query (qryMaintenanceInvoice). One of the report fields is "Subtotal" which is a calculated field in the query (Material cost x Qty.). This works correctly in the query and the report. The trouble comes when I try to add a calculated field in the footer of the subreport that adds up these subtotals. To do this I have created a field with the control source =Sum([qryMaintenanceInvoice]![Subtotal]) , however when I run the report I get #Error in the field box instead of the sum.
What am I doing wrong?
Mafhobb
What am I doing wrong?
Mafhobb