autonumber in make-table query

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!
 
D

Dan Artuso

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.
 
V

Van T. Dinh

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make Table Query and Autonumber Fields 6
Append query - Append to table with Autonumber field 2
Create table query... want to insert autonumber column 3
query that brings a autonumber field 6
Trouble with Query Results 11
How do you create an autonumber column in a query? 2
How can I make a field autonumber type in VB? 1
Update the values in a table from another table 1

Top