Problem with Make Table Query - Resultant Table not allowed to have more than one AutoNumber field.

  • Thread starter Thread starter Neil Robbins
  • Start date Start date
N

Neil Robbins

I'm trying to write a MakeTable query that will bring together data from a
number of tables and export it as a single table to another database.
Unfortunately when I run this query I get the following error "Resultant
Table not allowed to have more than one AutoNumber field."

Does anyone know a way of changing the Data Type of an autonumber field to a
compatible data type within a make table query.

Any help is always appreciated.

Neil R.
 
Just realised that I posted this to the wrong group. I have reposted to
access.queries.

Apologies
 
Back
Top