Newby Query Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
Asta said:
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?
Click to expand...

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
 
Asta said:
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?
Click to expand...

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.
 
Back
Top