Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2009

    Unanswered: Query Calculations

    I have a simple Access database to track golf scores. Basically the table has the following fields - date, course, score, fairways hit, greens hit.

    I need help doing the following calculations in a query, so that I can put into a Form.

    1. Show the High and Low score out of a specific range.
    2. Get the average of the last ten scores.
    3. Get the average of the last ten fairways and greens hit.

    Thank you for your help!



  2. #2
    Join Date
    May 2005
    Welcome to the forums.

    1. Look at the TOP clause.
    2. Again, the top clause, with a Sum divided by a Count function.
    3. Same as #2 with a WHERE clause.
    Me.Geek = True

  3. #3
    Join Date
    Feb 2009
    Thank you Nick for your reply.

    However, I am not familiar with the TOP clause and where that is entered. Do you enter the TOP clause in the Criteria field in the query or perhaps in Expression Builder? Not really sure how you use Expression Builder.

    I am a slightly past beginner with Access.

  4. #4
    Join Date
    Nov 2007
    Adelaide, South Australia
    Have a look at the properties for your query. You'll find one that says Top.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!

    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  5. #5
    Join Date
    Dec 2004
    Madison, WI
    I usually click the summization button (backwards E) and then will see the row under the column names to put the Top in.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Posting Permissions

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