Field calculated based on similar results...
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.