Results 1 to 5 of 5
  1. #1
    ScoobyDoo!
    Guest

    Displaying n number of records

    I have one that I've been struggling with that seems like it should be simple. I have a table with Names and scores and dates. I need to be able to capture the last 12 scores for each name. Does anyone have any ideas about how to do that?

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Displaying n number of records

    If this is an Access table, you'd be better off posting the question in the Access forum, since it would require addressing issues of relational table design. If you're talking about something like a Word table, you need to specify.
    Charlotte

  3. #3
    ScoobyDoo!
    Guest

    Re: Displaying n number of records

    It is an Access table, but it is one that is the result of a make table query that includes all of the data that I need. What I am thinking I need to do is open the table as a recordset, then step through the records, discarding each record after the first 12 for each person in the list. Does that sound like the easiest way to do something like that?
    I will also follow your suggestion and post this in the Access forum and see if anyone has any better ideas.

    Thanks!

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Displaying n number of records

    I'll follow up on this with you when you post it in Access rather than extending this thread.
    Charlotte

  5. #5
    ScoobyDoo!
    Guest

    Thank you!

    Charlotte, Thank you, I figured it out all by my lonesome, actually. The code that I was trying to use to evaluate the records was just not working. It turned out to be a duplicate reference that was confusing VBA. Once I cleared that up, my code worked just fine, and I'm on my way to a solution that seems pretty air tight. Thanks again, for trying to help.

Posting Permissions

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