Select record by row number

[kerrance76]

Hi

Is there a simple way of selecting a record from a table by row number, or filtering a recordset by row number?

I have a CSV file imported with transferText into tblImports, which creates an error file, the error file has a row number for any errors,
I would like to select these rows from tblImports by the row number, but cant figure out how to do it

Thanks

 

[boblarson]

Actually the row number is the row number in your raw data. In the table it doesn't necessarily store it in that same order so you may, or may not, be able to tell by opening the table and counting down. But, as far as programmatically, there really isn't a reliable way unless you maybe create a script to count down your raw records file to get it.

 

[kerrance76]

OK thanks for the quick reply I'll look at another way of correcting any errors