Record Numbering in a Query

[Ross]

How do I display the record number for each record returned from a select
query without affectiing the underlying table?

Is there a function that will do this?

Much Appreciated

Ross

 

[Van T. Dinh]

See Stephen Lebans' Web site:

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

HTH
Van T. Dinh
MVP (Access)

 

[Patrick Stubbin]

Select dcount("*",

) from xyz