I have a query that combines 3 different tables. When all three fields are filled in, the records populate, but not the records that don't have all 3 fields. When I apply what I learned in Beginner lvl 5 and use the 'Is Null' function to find those records that don't have the 3rd field, it populates no results. I want it to show all records even if it's missing one of the fields.
Daniel SchusterOP
@Reply 4 years ago
Daniel SchusterOP
@Reply 4 years ago
This picture shows my query and I need to tell it to show all records, even if 'BusinessName' is blank
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Beginner 5.