I am doing a project and Im supposed to display all the customers who havent bought anything from our company yet. I am using the customerID, customerFirtstname, and CustomerLastname. i am then using InvoiceAmount and in criteria putting "Is Null" yet when i run the query nothing comes up..? i have no idea what i am doing wrong... can anyone help me?
Question Problem showing empty cells
- Thread starter jc_
- Start date
It's hard to give any specifics without knowing anything about the structure of your database, but, as an example, if you want to show records from a Customers table that have no related records in an Invoice table, you could use a sub query with a Not In or Not Exists clause. More info on the subject here.
You are doing the right thing you just need to make the join between the customer table and the invoice table into an outer join. You do this by right clicking on the join and choose to get all data from the customer table!~)
so simple, yet so much trouble for me!
