Display RecNo

V

Viju

Hi,
I wanted to insert a new column to my query which will
show its corresponding record number. If the result of my
query will display 3 records, the new column will just
show numbers 1, 2, 3 record by record and in sequence.
Other databases such as dBase, Foxpro has recno() which
can display its record number but how will I do it in ms
access.

Thanking You,
VIJU.
 
Top