Newby Query Question

[Guest]

I have 2 tables, Each have relationships established and such.
Table1 has alot of information with each name and such
table2 has afew Names and such but not all

How would i create a query to list all the ones that arent listed?

 

[Tom Lake]

I have 2 tables, Each have relationships established and such.
Table1 has alot of information with each name and such
table2 has afew Names and such but not all

How would i create a query to list all the ones that arent listed?

Start a new query then use the Query wizard to create an unmatched query.
It will walk you through the process step-by-step.

Tom Lake

 

[Chris2]

I have 2 tables, Each have relationships established and such.
Table1 has alot of information with each name and such
table2 has afew Names and such but not all

How would i create a query to list all the ones that arent listed?

Asta,

Go to the menus at the top of the window.

Use: Insert > Query

When the dialog box comes up, select the Find Unmatched Query Wizard,
and see if that helps.


Sincerely,

Chris O.