Find the record number

[michelle]

Hello Access'ers

Is there a possibility to find the record nummer?
If yes can somebody give a source?

Nice regards,

Michelle.

 

[Pat Hartman]

Access doesn't use record numbers in the sense that ISAM files such as dbase did. Relational databases are unordered sets so by definition, sequence has no meaning.

If you have a need to track the order in which rows are added to a table, use an autonumber column or a date/time stamp and sort by whichever you choose when you create a query to retrieve rows.

 

[Sharda]

I agree with the previous reply. However you could use the CurrentRecord. This returns a long integer and can be used as a record number