unique numbers in query

[Craig]

I have a make table query and I want to add another column
that has unique values ie 1...n. There is no function to do
it, and the help isn't all that useful either.
Can someone steer me in the right direction please.
Thanks in advance.
Craig

 

[Van T. Dinh]

You can simply create the structure of the destination
Table first (including the AutoNumber Field) and then use
an Append Query to append the Records rather than the Make-
Table Query.

HTH
Van T. Dinh
MVP (Access)

 

[Guest]

Thanks very much

-----Original Message-----
You can simply create the structure of the destination
Table first (including the AutoNumber Field) and then use
an Append Query to append the Records rather than the Make-
Table Query.

HTH
Van T. Dinh
MVP (Access)



.