Replicate Row_Number from SQL in Access

[liammoohan]

I am using the below VBA code in an attempt to replicate Row_Number() which can be done in SQL

This is the query I have written:

SELECT A.*, (SELECT COUNT(*) FROM tblRowNosTest WHERE A.PhoneNumber = PhoneNumber And A.ListName = ListName) AS RowNos
FROM tblRowNosTest as A
ORDER BY PhoneNumber, ListName, ContactAttempts

This is how the results are then displayed:

Column 'D' is displaying as an overall count; what I am trying to get to is that I want it to show as below (see column 'E'):

Any help would be greatly appreciated in being able to get the query to output the results to look like the values in column 'E' as oppose to what it is actually outputting in column 'D' highlighted yellow.

Thanks

 

[Micron]

something like post 5 here?

Sequential Numbers in a query

Hello to all. I am new to this forum and have a problem that I am sure has an easy fix. I have a table of invoices that contains duplicate invoices. (There should be no duplicate invoices.) I have a query that identifies only the duplicate values, and a row exists for each duplicate invoice...

www.access-programmers.co.uk

 

[welshgasman]

You will need some field that is unique and in sequence to do it.

Have a look at any of these links from a quick Google

Replicate Row_Number access query - Google Search