query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The query cannot be completed. 1
Customer Query 1
two table query 10
Data Type Mismatch in Criteria Expression 2
Access Query problem 1
SQL Query Double Counts on Multi-Table Query 4
Data Type Mismatch in Criteria Expression 1
Access How to calculate the balance carried forward of individual student when payment of fee is made in ms access 2013 1

Back
Top