Select that is not in a table

  • Thread starter Thread starter Vina
  • Start date Start date
V

Vina

Can someone give me an idea on how to handle this.
I have 2 tables one has all data and one that i have code
for defective.

What i need is select only records that the codes is not
in that table.

Any ideas is appreciated.

Thanks
Vina
 
Can someone give me an idea on how to handle this.
I have 2 tables one has all data and one that i have code
for defective.

What i need is select only records that the codes is not
in that table.
Click to expand...

Use the "Unmatched Query Wizard" to find all records in Table1 that
have no matching record in Table2.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - retrieve data on last create named range from previous inserted named range 0
How to export table from outlook into ms access table? 0
Multiple Tables 1
How to Populate Data from a table to another 0
Seriously, I need ideas. Fields not transferring from table to table 3
Make-table query with around 2 ml records taking too long 0
Multiple Tables in Query not Listing Data. 2
Dates - Week to regulare date 2

Back
Top