Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Dec 2000
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Assigning Seq. Number to Query Results (2000-SR1)

    I would like to assign a sequential number, beginning with 1, to the resulting rows of a query. I have a form bound to this query on which I need to show this sequential number. Is there a function or property of some sort that I could use to obtain this number?

    TIA (As you can tell, I'm a relative novice at this! ). <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15>

  2. #2
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Assigning Seq. Number to Query Results (2000-SR1)

    You can find a good example of this at Rogers Access library.

    <A target="_blank" HREF=http://rogersaccesslibrary.com/download.asp?SampleName='NumberedQuery.mdb'>Number ed Query</A>

  3. #3
    Lounger
    Join Date
    Dec 2000
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Assigning Seq. Number to Query Results (2000-SR1)

    Rupert:

    Thanks for the link. That's a great site. I'll definitely be making a lot of use of it <img src=/S/exclamation.gif border=0 alt=exclamation width=15 height=15>

Posting Permissions

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