AnsweredAssumed Answered

Counting number of records containing multiple specific fields

Question asked by JustinHesser on Jul 18, 2014

Title

Counting number of records containing multiple specific fields

Post

     I am trying to do a calculation that finds the number of records that fit multiple criteria.

     In my example, I am in the table called Event and want to count the number of records in the table Person that both relate to my specific event (having the field "fkEventCode" equal to the field "kEventCode" in my Event table) and have a value in the field "Exported?" in Person Table equal to 1.

Outcomes