Query Line Numbering

  • Thread starter Thread starter gcutter
  • Start date Start date
G

gcutter

I have a query that is pretty complicated that uses many other queries and
the final query needs to have the rows numbered like in Excel. SO if I have
200 records the numbering will start at 1 and end at 200. I have searched for
a couple hours and have not found a solution.

Any help would be appreciated
 
Add this in the SQL. Substitute your table and field name --
(SELECT Count(*) FROM [ChangeRequests] As AA WHERE AA.[Dateopen] <=
[ChangeRequests].[Dateopen]) AS RowNum

Use the table that is the LEFT of the join.
 
Back
Top