Results 1 to 4 of 4
  1. #1
    SeniorCitizen is offline Advanced Beginner
    Windows 10 Office 365
    Join Date
    Dec 2021
    Posts
    32

    Post Query Help

    Working on a bowling project. My table contains two columns of scores and multiple rows for each bowler. All bowlers do not bowl each time so one of their two scores may be zero. What I am attempting to do is create an average for each bowler Knowing that they all don't have the same number of games. In my query a can average but don't have the correct number of games.

    Bill 195 201
    Bill 214 179
    Bob 166 174
    Bob 155 177
    Bill 210


    Bill 0 228

    Might this take multiple queries to create such a report? Or maybe there is some magic that I am not aware of.


    Thanks for any help

  2. #2
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    Tell us more about the table and the data that it represents.
    Why two columns for scores and why multiple rows for each person.
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  3. #3
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,857
    Why two columns?
    Sounds like you should have a separate record for the second and a field to identify first or second.
    Then average is dead easy to calculate.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  4. #4
    RayMilhon is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2011
    Location
    Southern California
    Posts
    1,065
    Personally I would have more fields.

    Bowler name
    Date bowled
    Game #
    Game Score

    Rows would be like

    Bill 6/8/2023 1 210
    Bill 6/8/2023 2 175
    John 6/8/2023 1 115
    John 6/8/2023 2 120

    Average would be easily calculated for any time period.

Please reply to this thread with any new information or opinions.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums