Forum Discussion
Tony2021
May 26, 2023Steel Contributor
Add a row counter in a query
Hello, I have a query and I need to add a row counter. How can I do this? SELECT CoID, CompanyName from tblCompanies Example: 1 Co A 2 Co B 3 Co C I need to add the 1,2,3...n t...
- May 26, 2023
I found it online. I created a form and put a field on it. For anybody that wants to know the counter is by way of a function and the code is here:
https://www.experts-exchange.com/articles/33069/Sequential-Rows-in-Microsoft-Access.html
by Gustav Brock.
Tony2021
May 26, 2023Steel Contributor
I found it online. I created a form and put a field on it. For anybody that wants to know the counter is by way of a function and the code is here:
https://www.experts-exchange.com/articles/33069/Sequential-Rows-in-Microsoft-Access.html
by Gustav Brock.