Dont want to display 0.00 data on a query

[keiath]

I am running a query (I cant get this information any other way as its from a large table), it does what i want it to do, but is there a way to not display anything that is 0.00

Site Code	Exp Code	Expense Discription	SumOfE
0272S	52	General Expenses	0.00
0272S	54	Alarms/Access/Security/Entryph	0.00
0272S	55	All Grounds Maintenance	1293.00
0272S	62	Window Cleaning	0.00
0272S	63	Cleaning General	780.00
0272S	64	Refuse Collection	499.20
0272S	65	Repairs & Day to Day Maint	3316.38
0272S	67	Pest Control	0.00
0272S	79	Electricity	252.51
0272S	82	Water Rates	5478.50
0272S	86	Insurance Claims Paid	0.00
0272S	87	Insurance Premiums	0.00
0272S	90	Ringley Management Fees	0.00
0272S	91	Accountant & Solicitors Fees	0.00
0272S	92	RCS Legal Fees	0.00

Thanks

[RuralGuy]

Post the SQL for your query.

[keiath]

Query as requested, I know i can use the filter function on the sub-form but it wont default to not display anything with 0.00

[RuralGuy]

Switch to SQL view and post what you see there, please.

[keiath]

ah sorry here you go

SELECT [Invoices 2013].[Site Code] AS [Site Code], [Invoices 2013].[Expense Code] AS [Exp Code], [Expense Codes].[Expense Discription], Sum([Invoices 2013].E) AS SumOfE
FROM [Expense Codes] INNER JOIN [Invoices 2013] ON [Expense Codes].[Expense Code] = [Invoices 2013].[Expense Code]
GROUP BY [Invoices 2013].[Site Code], [Invoices 2013].[Expense Code], [Expense Codes].[Expense Discription]
ORDER BY [Invoices 2013].[Site Code], [Invoices 2013].[Expense Code];

[RuralGuy]

You're going to need to add a WHERE clause something like:
WHERE ([Invoices 2013].E) <> 0
...but I'm not really sure where. Maybe right after the FROM line.

[keiath]

Thank you, that worked perfectly

[RuralGuy]

Great! Glad we could help.