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

Autonumber field in Excel that behaves the same as Access 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Macro Loop 0
Numbered list problem 6
Removing Line Numbers 4
How do I set focus (and select text) on a text box on a modeless userform? 0
Section and Page numbering 0
How can I do Calculations in a Query? 2

Top