ROWNUM and Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

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


Gilles said:
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,
Click to expand...
Field1,... FROM Table) but in Access, it returns an error message.
 
Back
Top