Query Line Numbering

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
 
K

KARL DEWEY

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how match blanks in number field? 2
Combine Duplicates in Query 0
Group like numbers 4
Counting multiple memberships 1
Creating queries asking for counts 6
Help with a logical/calcuation query 0
How to auto create volume bands 6
Aligning beyond "Joining" in query--forcing blank rows to appear 11

Top