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?
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?
