ROWNUM and Access

[Guest]

Hi
I would like to generate an ID nr in the result of a SELECTstatement (Access DB)
In Oracle, the ROWNUM keyword does the job (SELECT ROWNUM as ID, Field1,... FROM Table) but in Access, it returns an error message
Does somebody know how to do it

Thank

Gilles

 

[Michel Walsh]

Hi,


You have either append the data into a temporary table (with an autonumber),
either to compute the rank of each record accordingly to some criteria (that
defines the postion of the record among the other records).


Hoping it may help,
Vanderghast, Access MVP

Hi,
I would like to generate an ID nr in the result of a SELECTstatement (Access DB).
In Oracle, the ROWNUM keyword does the job (SELECT ROWNUM as ID,

Field1,... FROM Table) but in Access, it returns an error message.