How to add sequential numbers to query resultset

[h_latha2k]

I want to be able to add sequential numbers to the query result set. For example if the records are:



ID Name
3423 Susan
3424 Mary
3425 Jim

I want the result to be

Serial No. Name
1 Susan
2 mary
3 Jim

I looked at all places but in vain. I have been trying the ROW_NUMBER() OVER ( ORDER BY (SELECT 1)) but it brings up syntax error in access.

Any ideas??

[orange]

see http://allenbrowne.com/ranking.html

[h_latha2k]

Please pardon me. I could not follow the link that u sent. I could not follow how to add sequential numbers with ranking. I checked those links earlier but could not follow. Further help is appreciated.

[RuralGuy]

PMFJI but maybe this link will be useful: http://www.lebans.com/rownumber.htm