Use a Report with Running Sum PropertyIf your objective is to generate a report then you dont want numbering to be. Function myOrdinal D as Integer as String Dim Suffix as String Select Case D Case 1 21 31. AccountNum 242 256 298 308 output table.
The following statement returns the records of the second page each page has ten records.
The RecordID would be a sequential number starting from 1. An addition to this could be adding the Ordinal or Suffix of st nd rd or th Just create a Function. To add criteria to an Access query open the query in Design view and identify the fields columns you want to specify criteria for. ZeroCounter This will start the record numbers at 1 each time you run the query.