Query explicit Id

[Yassirmosawi]

Hi, how can I add an ID field to a query, that should start with 1 (first record) and end with last record? It's a continuous number field.
My query conatains two fields: firstname, productid

[#2]

Take a look at

http://www.lebans.com/rownumber.htm
and/or
https://github.com/GustavBrock/VBA.RowNumbers