Backend Access 2000, I have two tables in Database called Sales and Purchase.
Print a record number in access report.
Found 6 results for Query A Recordset Activex V1.2.1.
You may need to produce a report or query which has each row of output numbered to enhance report readability.
This should work if you alias the subquery, and ' original select query text here' can fit.
How to: Create a DAO Recordset From a Query
Code To Loop Through A Recordset (FORM) – Microsoft Community