How to show row number in Access query like ROW_NUMBER in SQL

October 5, 2022 by Tarik

You can try this query:

Select A.*, (select count(*) from Table1 where A.ID>=ID) as RowNo
from Table1 as A
order by A.ID