[MS_AccessPros] Help with Delete Query

 

I have 2 tables. Table A is in a SQL DB (Linked to Access). Table B is
in Access 2010. I have a query that inserts an ID number from table A
into table B. This is working fine, except for the fact that table B
eventually gets a lot of records. I'm trying to write a delete query
that will delete any record from table B that isn't in table A. The
tables are joined by ID number (which is also the field that I'm
inserting into table B). I'm struggling figuring out how to write a
delete query using Where tableA.IDNUMBER <> tableB.IDNUMBER. Any ideas?

Thanks,

Troy Sherven

[Non-text portions of this message have been removed]

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 6
• New Files 1

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___