Query Not working

[keiath]

Hi Guys have a strange little problem:-

I import Invoices into a table:-

ID	Site Code	Invoice Date	PO	Invoice	Contractor	Invoice Amount	Expense Code	Exp Description	Lease Code	Status
1	0289S	20/09/2013	34660	3410	Dj Commercial Cleaning Ltd	25.23	62		A	Pending
2	0289S	28/09/2013	34606	1141	Platinum Landscapes	240.00	55		A	Authorized on 19/09/2013 by KF, Paid on 24/09/2013
3	0289S	03/09/2013	35311	2021	Clean And Green	167.00	63		B	Authorized on 19/09/2013 by KF, Paid on 24/09/2013
4	0289S	02/08/2013	35311	2015	Clean And Green	174.00	63		A	Authorized on 19/09/2013 by KF, Paid on 24/09/2013

That's all straight forward, that data is drive by the site code.

Then i Run a query that groups the invoices By Lease Code and Expense Code, in this query it only returns results for Group A

Site Code	Group Code	Exp Code	Expense Discription	SumOfInvoice Amount	Group Total
0272S	A	52	General Expenses	£210.09	0.00
0272S	A	55	All Grounds Maintenance	£9,666.20	10,347.53
0272S	A	59	All Lift Expenditure	£499.20	0.00
0272S	A	64	Refuse Collection	£4,881.11	1931.91
0272S	A	67	Pest Control	£1,146.00	0.00
0272S	A	79	Electricity	£1,294.59	0.00
0272S	A	87	Insurance Premiums	£255.51	274.47
0272S	A	91	Accountant & Solicitors Fees	£2,880.00	2880.00
0272S	A	92	RCS Legal Fees	£939.69	915.22
0289S	A	52	General Expenses	£986.88
0289S	A	54	Alarms/Access/Security/Entryph	£878.65
0289S	A	55	All Grounds Maintenance	£24,188.72
0289S	A	58	Drain Clearance (Contracts)	£892.20
0289S	A	62	Window Cleaning	£4,791.23
0289S	A	63	Cleaning General	£9,837.00
0289s	A	64	Refuse Collection	£1,140.25
0289S	A	65	Repairs & Day to Day Maint	£13,700.13

Now I just added a new bunch of invoices that are clearly in the Table, but when I run the query its not showing anything for site code 0170S, I checked all the data to ensure its 'the same' as all the others

Any ideas why this is happening?

Thanks in advance

[June7]

No idea. If you want to provide db for analysis, follow instructions at bottom of my post.

[keiath]

I have actually worked it out by process of going though and removing bits. The 'Group Code' is actually Previous year Group Total that comes from another table. Because the Exp Code is part of a relationship with both tables, if I dont have the code in the Previous year table it doesn't display anything.

So as it stands I would have to ensure that previous years amounts are inputted first, unless there is a way around that problem?

[June7]

Sorry, don't understand the circumstances as described. Don't know the data structure.