Hi guys
I have this subform problem
I import all the invoices for the client
ID Site Code Invoice Date PO Invoice Contractor Invoice Amount Expense Code Exp Description Lease Code Status A B C D E F 771 0038S 14/05/2013 34795 MAY-LD1595 Living Decor 1000.00 65
A Authorized on 20/05/2013 by LD, Paid on 24/05/2013 0.00 0.00 1000.00 0.00 0.00 0.00 772 0038S 30/09/2012 99276 9001399 Rouse Partners Llp 2880.00 91
A Authorized on 06/03/2013 by MAB, Paid on 11/03/2013 0.00 0.00 2880.00 0.00 0.00 0.00
in another table I have previous Year Expenses and Budgets by Expense Code
ID Site Code Group Code Expense Code Expense Discription Group Total Budget 43 0038S A 91 Accountant & Solicitors Fees 950.00 700.00 44 0038S A 92 RCS Legal Fees 407.00 415.00 45 0038S A 65 Repairs & Day to Day Maint 1523.00 3500.00 46 0038S A 90 Ringley Management Fees 3837.00 4500.00
But on the Subform its only showing the group totals where there is an invoice for that expense code, and not showing Previous Years and Budgets where there is no expense in the current year
Expense Discription Exp Total P/Y Total Budget Repairs & Day to Day Maint 1000.00 1523.00 3500.00 Accountant & Solicitors Fees 2880.00 950.00 700.00
Any idea how I can correct this?
Thanks in Advance