In searh of hidden Record Number for use in a query

[turtlpc]

I know ACCESS has an internal record number, but I am unable to figure out how I can access it for use in a query. What I would like to do is create query that searches a couple of tables and returns x number of rows, from which I would use a record number to select a specified record(row).

Thanks

 

[IFELSETHEN]

I did a search on Google and MSDN and found nothing about Access. I did find that you can get the record number for MySQL, SQL, Oracle, INFOMAX but not Access. Auto numbering won't do?

 

[turtlpc]

Unfortunately the Auto Numbering will not do as the 'auto' record number is deleted along with a record deletion. Thereby not providing an accurate record count, which is what I'm looking for. Thanks for your efforts

Phill

 

[MichaelRed]

It would help if you were specific about your request. Record Number <> Record Count, so re-state your needs.

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over

 

[turtlpc]

It's the record count we're looking for on returned rows in a query. Internally access maintains a record count, but how can we access it for use?
We would like to create query that searches a couple of tables and returns x number of rows, from which I would use the record count to select a specified record(row).

 

[SBendBuckeye]

I would like to know the answer to this as well. My email address is in my profile.

Thanks,

SBendBuckeye

 

[MichaelRed]

RecordCount returns the number of records in a recordset, just as Count(exp) will do in SQL. Within the instantiation of a recordset, Ms. A. maintains the 'bookmark' property of each record. [RecordCount | Coount(exp)] have no relationship in this regard. The bookmark of a specific record may in fact even change with different instantiations of the recordset. The bookmark property is 'officialy' refered to as a string, although is 'looks' a LOT like the old packed numeric format. I'm sure this is NOT what you are looking for, but then I am REALLY REALLY REALLY not sure what you are trying to do with the disseperate concepts. You can easily instantiate any / all recordsets and loop through them, retrieving information (including the bookmark, field names, values (content) and other properties). It is possible (although somewhat foregin to general practice) to get the record count of the recordset and use that value as the terminiation value of a fixed loop to retrieve (or set) some of the above. It still does not relate to the actual record 'identity'.

Actually, the concept of a &quot;Record Number&quot; is somewhat foregin to the rules of relational database.

Hopefully, these ramblings do not worsen your confusion (very much).

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over