AnsweredAssumed Answered

Field calculated based on similar results...

Question asked by RandyFinger on Oct 29, 2012
Latest reply on Oct 29, 2012 by philmodjunk

Title

Field calculated based on similar results...

Post

     Hi.

      

     I have a database that houses information on an award recognition system we have set up.  One person can have multiple records in the database because it's entered in as a brand new record every time they get recognized.  I want a field that calculates on the record how many times that specific person is in the database (i.e. how many times they've gotten an award).  I want it to count the number of records in the database in which the first name field, last name field, and site field all match those on the current record.

      

     Is there a way to easily calculate this?  I'm wrapping my head around how I think it should be set up, but am not able to fully grasp the code I need for it.

      

     Thanks!!!

      

Outcomes