Formating multiple Autonumbers for a make table query

[action]

As I have failed to find the answer in existing posts so I'll ask it..

I have a make table query which is pulling two Autonumbers from two tables, which it doesn't like. Can I format them into general numbers and add a new auto number as the primary key?

If so how? I assume its using the format function but don't know much about this.

Thanks in advance

 

[neileg]

An autonumber field returns a long integer. This behaves like any other long integer, so there's no reason why this should cause a problem. There's no need to format these fields as anything. I thinl your problem is something different.

If I have a problem with a query, I build it as a select query first, then convert it to a make table, or whatever.