Current Record Number use in a query

Topic

New Reply

I want to use the Current.Record property in a query. Is this possible? This is different to the Record ID generated when a record is created. I simply want to be output the current record number of the records within this query.

Your assistance would be most appreciated.

Reply | Quote

Replies

Unfortunately that is something that is either very difficult or impossible to do in a query. You can do all sorts of things with a DAO or ADO recordset to create a sequential number, but queries don’t really have that ability, and unless the query has a unique sort specification, that record number for a specific record may change from execution to execution. It is possible to do something like that on a form or a report – see Report Recordset for the latter. Would something like that be useful?

Reply | Quote

Thank you for your response Wendell. Yes I figured it was not going to be easy. I ended up with a work-around that I found. This is the link for interest. http://www.bytes.com/topic/access/answers/193760-easy-sequential-record-numbers-access-queries

Reply | Quote