Row number of records as they are fetched

[Prateek]

I have 4 tables, from which i select data with help of
joins in select query...I want a serial no.(row number)
per record as they are fetched. first fetched record
should be 1, next 2 and so on...

In oracle the equiavelent in RowNum.

 

[Van T. Dinh]

Try Stephen Lebans' rownumber:

http://www.lebans.com/rownumber.htm>

HTH
Van T. Dinh
MVP (Access)