I know there's a simple answer!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jezzsj@gmail.com - 26 Mar 2007 16:45 GMT

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

Reply to this Message

Al Campagna - 26 Mar 2007 16:58 GMT

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

Signature

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."

> Hi,
>
[quoted text clipped - 4 lines]
>
> Thanks

Reply to this Message