I have a query that is based on two tables; main quote table and the product table. In the product table I have a yes/no box for if that product was purchased. What I want the query to do is run and display all the quotes that do not have a the check box checked; however, I want the whole quote displayed even if there are products that were purchased. Is this possible?
Showing records matching criteria and including non matching records
- Thread starter hrseebeck
- Start date
