AnsweredAssumed Answered

Calculation based on 2 fields

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

Title

Calculation based on 2 fields

Post

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

 

Thanks

Outcomes