Simple Query on condition

[Waheed2008]

Hi all,
Again bothering you for a very simple thing.
I have a table Expenses having fields
ID, InvoiceNo, Date, Expense, Approved

Where Approved is a check box. I want to build a query (from Queries) such that along with other things, my query shows Total Expenses off all invoices and Total Expenses of approved invoices.

I have attatched sample database file. Can any body help me?

Thanks

 

[khawar]

Download the attached sample

 

[Waheed2008]

Thanks Khawar,
I have used this method and it gives me solution.
Thanks again...