how to assign autonumber to fields in access query?

[1661]

Hi,

How can I assign autonumbers to the fields in an access query?

Please help.

Thanks

 

[LittleSmudge]

I don't understand your question.

An AUTOnumber field is "By Definition" Read Only.

Read Only seem incompatible with the term "Assign".


What are you asking ?





G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[1661]

Sorry, I should have been more clear. When I say assign, I mean if I am writing a select query: I could be selecting a part of the primary key (and since its a part of the PK, they will not be unique). How can I assign (generate) an auto number(in order 1,2,3,4....so on) in this scenario so the selected records can all be unique.

I hope this clarifies your question.

Thanks