I wonder If anybody can help.
I am creating a db to hold the results for my local Cricket Club and calculate the averages.
To calculate the average you need to total the runs scored and divide by the number of innings. However if a player is 'Not Out' then you add the runs but don't include that innings when calculating the avergage (this is the problem)
I have a table as follows
Player ID - Runs Scored - NotOut (Yes/No Field)
Could anybody help me with creating a query to perform this calculation
It would be very much appreciated
I am creating a db to hold the results for my local Cricket Club and calculate the averages.
To calculate the average you need to total the runs scored and divide by the number of innings. However if a player is 'Not Out' then you add the runs but don't include that innings when calculating the avergage (this is the problem)
I have a table as follows
Player ID - Runs Scored - NotOut (Yes/No Field)
Could anybody help me with creating a query to perform this calculation
It would be very much appreciated
