This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I imported a bunch of data (basic contact info) from Excel into an existing Access table. The additional data is visible in the table, so I assumed the import worked. However, I've noticed that when I do a query that includes said data, only the data that has been activated (i.e., a new record added in a related table) shows up in the query. I did a straight up query searching for all 102 records, but the query returned only 71 records, all of which had a new record added in a related table since the import. None of the "non-activated" data appears even though it is visible in the table. What's going on? How do I engage the "non-activated" records?
Bob
A family of Microsoft relational database management systems designed for ease of use.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(284.8, 62%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDH%3C/text%3E%3C/svg%3E)
I’m not sure how your data is organized but the left or right joins are necessary of there are “orphaned” records.
Is there an alternative? Can I do something to the imported data in the table?
You would need to edit the join for every query that doesn’t have matching records in both tables.
Success! Thank you Duane.
What happens in the future? I imported data from 5 districts. I presented only 1 in my question. I did a quick sample query to include all districts, and I found that I had to change the properties setting to include ALL records. Do I have to change the Join Properties setting every time? It was pure luck that I noticed the omissions this time. In the future, I may not be so observant or congizant.
Bob
While in the query design, double-click the join line to view the properties. Set the join to include all of the records from one of the tables. Then try view again.