Selective copy operation

Access 2013 - Desktop database
I'm attempting to copy selected records from one table (A) to another (B) dependent on yet another table (C)
Each table has the field "idnumber" which is a long integer.  IN fact all fields in all tables are the same.
C has the controlling list of idnumbers
I want to copy records from A into B if a.idnumber is in the c table.
I've used
INSERT INTO B select * from A where A.idnumber in (select idnumber from c);
but it copies every record in A .  I tried a couple of other techniques but no joy.
(Yes, I need a separate copy of the records in a table since I'm using table B in other databases via linked.
ideas?  does anyone have the specific statement which might work?
LVL 4
Keyboard CowboyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rey Obrero (Capricorn1)Commented:
<but it copies every record in A >

maybe, all idnumbers from A are in C

to check run this query

select * from A
Inner join C on A.idnumber=c.idnumber

check the number of records return

open table A and see how many records you have.

if they are the same, then all records in A are in C based on the idnumber field.
0
Rey Obrero (Capricorn1)Commented:
also, try

INSERT INTO B select * from A Inner join C on A.idnumber=c.idnumber
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Keyboard CowboyAuthor Commented:
Checking - thanks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.