Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Apr 2002
    Location
    Northern Territory, Australia
    Posts
    471
    Thanks
    16
    Thanked 0 Times in 0 Posts

    Current Record Number use in a query

    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.

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts
    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?
    Wendell

  3. The Following User Says Thank You to WendellB For This Useful Post:

    kerryg (2015-07-05)

  4. #3
    4 Star Lounger
    Join Date
    Apr 2002
    Location
    Northern Territory, Australia
    Posts
    471
    Thanks
    16
    Thanked 0 Times in 0 Posts
    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/an...access-queries

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •