Calculating in a form

[keiath]

I have a subform in columns that has a list of invoices bound together by the site number on the form there is a Expense code that runs 51 to 95.



on another tab i want to add all the invoices for a expense code together and display the total amount

Below is an example of invoices


ID Site Code Invoice Date PO Invoice Contractor Invoice Amount Expense Code
1 0289S 20/09/2013 34660 3410 Dj Commercial Cleaning Ltd 25.23 62 A
2 0289S 28/09/2013 34606 1141 Platinum Landscapes 240.00 55 A
3 0289S 03/09/2013 35311 2021 Clean And Green 167.00 63 A
4 0289S 02/08/2013 35311 2015 Clean And Green 174.00 63 A
5 0289S 19/08/2013 11111 5271 Southern Electric 189.56 79 A
6 0289S 19/08/2013 34606 1121 Platinum Landscapes 240.00 55 A
7 0289S 02/06/2013 35311 2009 Clean And Green 160.00 63 A
8 0289S 02/05/2013 35311 2003 Clean And Green 181.00 63 A

I want it to display on another tab

51 General Expenses £452.36
55 Gardens £1523.65

and so on

whats the best way to do this?

[ssanfu]

On a different tab, use another sub-form. The recordsource for the sub-form would be a totals query.

[keiath]

Thank you never thought of doing it that way