Calculation based on 2 fields
I am working on a database to track statitistics during college bowling tournaments.
I cannot figure out a way to track total records based on values in 2 fields.
Total single pin spares - I have fields for to pins knocked down on the first ball and a field to indicate that a spare was made.
How do I count the records where first ball count = 9 and mark = y ?
The statistics are being stored in a seperate table in the same database. I can get totals for records where I only need to look at a single field (like total strikes).