sql - Displaying Row numbers column at runtime

Question

I have an employee table with has name, age, city as columns. I want to display a column at run-time for my row numbers starting from 1. I am using SQL in Access.

Answer 1

Call the following function from your query.

Public Function GetNextNum(str As String) As Long
    num = num + 1
    GetNextNum = num
End Function

The caveat is that you must have at least one parameter (even if you don't need one) otherwise the function only gets called once and returns 1 for all the rows.

Before running the query set the global variable num to 0.