autonumber in make-table query

  • Thread starter Thread starter j.gawlik
  • Start date Start date
J

j.gawlik

I need to populate a field in a make-table query with an autonumber. When I
do this with an integer value of 2, I use "MyNum: cint(2)". How do I create
an autonumber data type?

Thanks!
 
Hi,
An autonumber field is refered to as 'Autoincrement'
But you won't be able to insert a value into it as the whole point of them
is that the database engine handles that.
 
The simply way is to create the (destination) Table Structure first and then
use an Append Query to add Records to the destination Table rather than the
Make-Table Query.
 
Back
Top