Showing serial #

[Nad]

Hi Guys,
I made a simple query in which i want to add an additional column to show
the serial # of the records (1,2,3...). I do not want to put serial# field
into the table.

Thanks & Regards,

 

[Allen Browne]

There's not a really simple solution, but see:
Ranking and numbering records
at:
http://allenbrowne.com/ranking.html
for several possible approaches.