query

[Maria]

I'm new to Access and am trying to put together a database. I have four
queries: sum of invoices, sum of payments, balanced owed, and outstanding
invoices. I am trying to consolidate this information into one query - which
will also show our fee for services.

My problem is that I want the query to show the fee whether or not I have
invoiced the project. What I am getting now omits any project fee that I
have not invoiced. Any suggestions on how to do this?

Thanks

 

[[MVP] S.Clark]

I'd assume that you have an Inner join to the Invoices table. This causes
the UNinvoiced ones to be excluded. Try switching the join type.

 

[Maria]

Thanks so much! I knew the answer had to be an easy one.