2I have a query which contains two fields (for the purposes of this example, anyway):-\[code\]RecordIDRecordDate\[/code\]This table is sorted by RecordDate (ascending).I would like to find out the position within that query of a specified value in RecordID.So, for example, if my table contains the following:-\[code\]10 15/2/198911 15/3/198912 15/4/198913 15/5/1989\[/code\]And my value is '11', then I want to return row number 2...is this something that is possible?
Returning the row number of a matched value in a table
- Thread starter dire2dark
- Start date