Count query without using totals to avoid redesign of existing functioning query

[davesaintjay]

Oh right - you can't refer to the name of a control, you must refer to fields on the record source. On your report footer you have copied the first two totals directly from the InvoiceID footer, you must do the same for the third field as well. Its control source must match the field on the invoice id footer.

Ok great. I see what you're saying with regards to the control source etc and that I need to refer to the fields directly. But how would I perform this calculation as the orderoverheads and postagepaid only apply once for each invoice?



If I use this in the report footer then it will Sum those 2 fields for every order line within every invoice which is fine for the first two fields but not orderoverheads and postage paid:-

=Sum([transuk]-[productoverhead])-[orderoverheads]-[postagepaid]

Many thanks

[aytee111]

Make a query that gives you the exact figure that you want. I don't know if your report is filtered, if it is the use the same criteria. Then in the control source of the field use dlookup: =DlookUp("calcfieldname","queryname","criteria(opt ional)")