2 tables to 1 table

[wutaguy]

I have 2 tables. I would like to join the 2 and come up with a table that has records that is NOT in both tables.e.g.

Table 1 has Field A with records 1,2,3,4,5
Table 2 has Field A with records 1,2,3,4,5,6,7

I want Table 3 to only have 6, 7.

Sorry I am just a beginner. Any help will be appreciated.

Thanks

 

[Zigzag]

Hi wutaguy,

If no one else replies to your question, post your tables on here an I will have a play with them and attempt to produce a solution for you.

Garry

 

[boblarson]

I have 2 tables. I would like to join the 2 and come up with a table that has records that is NOT in both tables.e.g.

Table 1 has Field A with records 1,2,3,4,5
Table 2 has Field A with records 1,2,3,4,5,6,7

I want Table 3 to only have 6, 7.

Sorry I am just a beginner. Any help will be appreciated.

Thanks

Look into using the UNMATCHED QUERY WIZARD to create the query. Just go to the queries and then NEW and select UNMATCHED QUERY WIZARD and follow its prompts.

 

[wutaguy]

Thanks for reply.

When I try "Find Unmatched Query Wizard" Access says feature not installed. When I try to install, then it says missing SKU011.cab file.
I am not supposed to post tables as it contains confidential information.

 

[boblarson]

Thanks for reply.

When I try "Find Unmatched Query Wizard" Access says feature not installed. When I try to install, then it says missing SKU011.cab file.
I am not supposed to post tables as it contains confidential information.

If it says "not installed" then you need to get your admin to reinstall your Office installation using CUSTOM installation and selecting all of the applicable items with RUN FROM MY COMPUTER.

But, basically you would create a query that is something like this:

SELECT TableA.[FieldName]
FROM Orders LEFT JOIN TableB ON TableA.[FieldName] = TableB.FieldName
WHERE (((TableB.FieldName) Is Null));

replacing FieldName with the applicable field names

 

[wutaguy]

Thanks!!

I wish I was as smart as you Bob!

That worked.