AnsweredAssumed Answered

Calculation based on 2 fields

Question asked by zosodp on Jun 19, 2012
Latest reply on Jun 19, 2012 by philmodjunk


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.


For example,


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).