Resultant table not allowed to have more than one AutoNumber Field

[Joel]

I get this when trying to create a table (one time, then I will delete
and populate) from a query.

I have seen good answer to this if my query includes autonumber fields
but my query does not contain ANY autonumber fields. I can't understand
why I'm still getting this error.

Any ideas?

Joel

 

[Duane Hookom]

Do you mind sharing your SQL view of your query as well as the field data
types?

 

[Joel E via AccessMonster.com]

Ok I feel dumb. There were indeed autonumber fields. Put me on your "ignore"
list now

Joel

Do you mind sharing your SQL view of your query as well as the field data
types?

I get this when trying to create a table (one time, then I will delete
and populate) from a query.

[quoted text clipped - 6 lines]

Joel

 

[Duane Hookom]

"Here's your sign" ;-)

--
Duane Hookom
MS Access MVP

Ok I feel dumb. There were indeed autonumber fields. Put me on your
"ignore"
list now

Joel

Do you mind sharing your SQL view of your query as well as the field data
types?

I get this when trying to create a table (one time, then I will delete
and populate) from a query.

[quoted text clipped - 6 lines]

Joel