is there any function

[Anon]

hi,

i want to know if there is any way i can display the row number and row id, when i write select statement to extract the data from the table in MS access.

select <row number ?>, <row id?> , [column..] from [table];

thanks

andy