How do I change an autonumber field into a regular number field in a make-table query?

Hello,  I am running a simple make-table query.  I have two tables, tbl_Contacts and tbl_Categories, each of which has an auto number field.  In tbl_Categories, the auto number field is IdCategory.  As shown in the SQL below, I am trying to make a table, "temp" that includes all records from tbl_Contacts in addition to IdCategory from tbl_Categories.  I would like the field IdCategory to be an integer field in my new table but Access tries to bring it in as an auto number.  How can I change IdCategory into an integer in the course of running this query?

SELECT tbl_Contacts.*, tbl_Categories.[IdCategory] AS IdCategory2 INTO temp
FROM tbl_Categories RIGHT JOIN tbl_Contacts ON tbl_Categories.Category = tbl_Contacts.Category;
SaleveAsked:
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.

PatHartmanCommented:
You may be able to coerce Access into doing it your way by using a function.

Select cLng(YourID) as NewID .....
0
Rey Obrero (Capricorn1)Commented:
try this


SELECT tbl_Contacts.*, clng(tbl_Categories.[IdCategory]) AS IdCategory2 INTO temp
FROM tbl_Categories RIGHT JOIN tbl_Contacts ON tbl_Categories.Category = tbl_Contacts.Category;
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
SaleveAuthor Commented:
Perfect.  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.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.