Creating a report with calculations

[Normantom]

Hey
Im getting really frustrated and hope you can help.



I want to produce a report which calculates the total for how much the customer will be charged for work by multiple labourers, and i want to calculate how much the customer will be charged for multiple items that are to be used on the job.

I have created a query that will calculate the tax, and the total and the subtotal, but I havent a clue how to calculate multiple "ItemCosts" (each having the invoice number as the relationship) and multiple "LabourCosts" (again each having the invoice number as the relationship).

To give you an idea of the relations in the database, below I will attach the database.

Please see the "Invoice" query.

Thanks

[Datagopherdan]

I didn't open your database but from what you're saying, you should just be able to do group level headers and footers in your report to give you figures for each customer. You would create a customer header and footer and in the detail section you would have all those line items with a calculated field of the totals in the footer section.

If you do a google search on Access Report Groupings, you'll find alot of exampled on how to do it.