Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Maine, USA
    Posts
    258
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Numbering items in a query (2000)

    Is there any way to get a query to assign numbers to the items it finds? Specifically, if the query comes up with five names, I want them numbered 1-5. If the next time it runs it comes up with seventeen names, I want them numbered 1-17. The numbers do not need to be stored anywhere for later use - they can go away when the query closes. I thought I might be able to do this somehow with a counting query, but at least so far I haven't figured it out that way or any other way.

    thanks,
    -cynthia

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Numbering items in a query (2000)

    Here a sample database to number a query. It has been posted in a previous post but I don't find it again.
    Attached Files Attached Files
    Francois

Posting Permissions

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