Results 1 to 3 of 3

Thread: Query Question

  1. #1
    Join Date
    Dec 2004
    Location
    Fort Worth, TX
    Posts
    43

    Question Unanswered: Query Question

    I am building a database in access2000 for my golf league and want to autocalculate handicap's. I need to know how I can do the following:

    Show last 20 scores (by date)
    take the avg of the 10 lowest scores and multiply that by .95

    I would like to do this in a query but can't figure out how to limit records

  2. #2
    Join Date
    Aug 2004
    Location
    Steamboat Springs, CO
    Posts
    37
    Under View --> Properties you can set the maximum return for a query. This would limit the return for the entire query. Just a matter of developing the proper report to plug in the query for every player.

    Jeremy

  3. #3
    Join Date
    Dec 2004
    Location
    Fort Worth, TX
    Posts
    43

    Wink

    OK I got it now. It's a little longwinded but will do the trick. I was thinking that THere was a SQL statemtn that was the opposit of SELECT TOP 10 (Like BOTTOM 10) but it's all how you put the order by.

    I will probably have more questions concerning this dbase later on but I have the information I need to continue pluggin away.

Posting Permissions

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