troubleshooting Question

Query does not show records with no connection to second table

Avatar of rltomalin
rltomalinFlag for United Kingdom of Great Britain and Northern Ireland asked on
Microsoft Access
3 Comments1 Solution237 ViewsLast Modified:
I may be missing something here, or maybe trying to do something impossible.

I have two tables - Jobs and Volunteer

The Jobs table has a Volunteer ID field so that there is a relationship between the two tables.

I create a query that pulls data from both tables.  This works fine of course.

But if I have a job in the Jobs table that does not have a matching volunteer (ie the VolID is blank) , then that job does not appear in the query.
What I need is for the query to display all jobs, even those without a volunteer connected.

Can I do that, and if so how please?

Best regards


Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros