Remove Records from One Table That Are Unmatched

  • Thread starter Thread starter Nicole
  • Start date Start date
N

Nicole

Hi Can someone please help me.
I do not have any experience in Visual Basic or
programming.

All I want to do is Remove Records from Source Table That
Are Unmatched!!

What do I do!!!

Thanks,

Nicole
 
Hi Can someone please help me.
I do not have any experience in Visual Basic or
programming.

All I want to do is Remove Records from Source Table That
Are Unmatched!!

What do I do!!!

Thanks,

Nicole
Click to expand...

A Delete query will do this: Create a Query by adding the Source table
and the other table (I'll call it Other) to the query grid. Join them
on the desired linking field. Select the JOIN line and choose option 2
- "Display all records in Source and matching records in Join".

Select the * pseudofield from Source and *only* the linking field from
Other. As a criterion on this field put

IS NULL

Uncheck the "Show" button on this field.

This will restrict the query to only the unmatched records. You should
now be able to change it to a Delete query. Run it and you'll delete
the unmatched records.

BACK UP YOUR DATABASE FIRST, of course!
 
Back
Top