delete records that exist in another table

G

gymphil

Can anyone please tell me the best way to delete records in one table where
the same record exists in another table?

Thanks
 
J

Jerry Whittle

Is there a primary key field in both tables and does that PK identify the
same record?

Also if this is something like "Active" and "Closed" tables where data is
move from one to the other as the status changes, the correct answer is that
you don't. Rather you have only one table with a Yes/No field called
something like Active. That's how you tell which records you want to see.
 
J

Jeff Boyce

I'm with Jerry ... why do you have "duplicates" in two tables? Is this an
artifact of construction/development that you're now cleaning up? What is
the relationship between the tables?

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
L

Lord Kelvan

that or what are the fields that you see as the duplicate fields and
the table names
 
G

gymphil

Jerry,

Apologies for the delay in responding to your message.
I have done as you sugested and opted for the yes/no field in one table, it
works great and is a lot simpler than transfering records from table to table.

I appreciate your assistance

Phil
 

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

Setting column width in a table with a macro is not working 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
VBA to see if a Section exists in Word Document, and if it does, delete it 2
Create a chart from a table in word thats dynamic 0
M.S. Word 365 1
Dealing with a Pivot Table (when I don't want to) 0
How do i delete an old Outlook account from ex employers? 1
Crating User Form to Add Names 1

Top