Changing Field definition within a query

[gm_lowery]

I need help figuring out how to change the autonumbers in my query to long values. There are currently two autonumber fields Series ID and Session ID and I want change Session ID into an integer. I have tried some of the coding examples but I keep getting errors saying that it is not formatted correctly could somebody please help.
below is a picture of the design view with the one I want to change circled.

[JoeM]

If the fields truly are set up as Autonumbers, by default, they should have been set up as Long Integers.
Why do you want to change them?

[gm_lowery]

Because I am not allowed to have two autonumbers in a make table query.

[JoeM]

What exactly are you trying to do (in relation to building a make table query)?
What is the purpose of the "make table" query?
The reason why I ask is because I often see people mistakenly think they need to write information back to a new table as opposed to just using a query.
So if we understand what you are trying to accomplish, we may be able to make better suggestions.

[gm_lowery]

It is an archiving table. So basically i just have to archive this data that this query picks up.

[JoeM]

Instead of using a Make Table Query, I would recommend setting up the shell of the table the way you like, and then use an Append Query to write the data to it.
You would set up these two fields as Long Integer fields in this new table, but NOT Autonumber fields. You cannot write anything to an Autonumber field since it is automatically assigned.