Autonummer fra 1 og opefter i forespørgsel

You need to make a calculated field in your query. Here is an example, where you can see that the sub select calculates the order number.

SELECT Emp1.LastName, Emp1.HireDate, (Select Count (*) from Employees Where [ID] < [Emp1].[ID])+1 AS OrderBy
FROM Employees AS Emp1
ORDER BY Emp1.ID;

.

tak:o)