By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,401 Members | 814 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,401 IT Pros & Developers. It's quick & easy.

Delete based on another table

P: n/a
Hi all!

I am new to this and trying to learn as best as i can. This group is
defiintely helpful in that regards. Anyways, I was wondering if
someone can help me with this:

I have a table called for example BigTable and I have another smaller
table called SmallTable - both tables are joined at the Account field.
I want to set up a query in Access which would allow me to delete all
records from BigTable which are NOT in SmallTable based on the Account
field. I've been trying to figure this out and can't seem to do so -
please help! Let me know if you have any further questions.

I thank you all in advance for your help.

-Haas
Sep 17 '08 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Wed, 17 Sep 2008 14:15:27 -0700 (PDT), Haas C <ha*****@yahoo.com>
wrote:

Interesting how you unconsciously gave a major part of the answer
yourself:
delete from BigTable
where Account NOT IN (select Account from SmallTable)

-Tom.
Microsoft Access MVP
>Hi all!

I am new to this and trying to learn as best as i can. This group is
defiintely helpful in that regards. Anyways, I was wondering if
someone can help me with this:

I have a table called for example BigTable and I have another smaller
table called SmallTable - both tables are joined at the Account field.
I want to set up a query in Access which would allow me to delete all
records from BigTable which are NOT in SmallTable based on the Account
field. I've been trying to figure this out and can't seem to do so -
please help! Let me know if you have any further questions.

I thank you all in advance for your help.

-Haas
Sep 18 '08 #2

P: n/a
On Sep 17, 11:26*pm, Tom van Stiphout <tom7744.no.s...@cox.netwrote:
On Wed, 17 Sep 2008 14:15:27 -0700 (PDT), Haas C <haas...@yahoo.com>
wrote:

Interesting how you unconsciously gave a major part of the answer
yourself:
delete from BigTable
where Account NOT IN (select Account from SmallTable)

-Tom.
Microsoft Access MVP
Hi all!
I am new to this and trying to learn as best as i can. This group is
defiintely helpful in that regards. Anyways, I was wondering if
someone can help me with this:
I have a table called for example BigTable and I have another smaller
table called SmallTable - both tables are joined at the Account field.
I want to set up a query in Access which would allow me to delete all
records from BigTable which are NOT in SmallTable based on the Account
field. I've been trying to figure this out and can't seem to do so -
please help! Let me know if you have any further questions.
I thank you all in advance for your help.
-Haas- Hide quoted text -

- Show quoted text -
LOL. Thanks!! Shoulda listened to myself. Appreciate the help!
Sep 18 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.