I know there's a simple answer!

J

jezzsj

Hi,

I have two tables, table a and table b, I want to run a query that
will remove any records from table a that are not contained in table b
the result being table c or something similar. Any assistance would be
appreciated.

Thanks
 
A

Al Campagna

Jezz,
Step 1... Backup
Step 2... Backup :-D

Create a select query with A linked to B... "All in Table A, and only those in Table B
that match"
Use this realtionship as the basis for a MakeTable query to send all those A records
that have a B record... to a new table.
Then, use that same basic query to run a Delete query against Table A

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."
 
Top