Hello Access'ers

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

Nice regards,

Michelle.

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.

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