If you have one record (row) for each referral with an employee ID and a date, you can set it up this way:
Define a summary field in the Referral table as the "count of" a field that is never empty such as the date field.
Define a relationship between the employee table and the referral table like this:
Employees::EmployeeID = Referrals::EmployeeID
This will match an employee record to all referral records with a matching EmployeeID. Now we just need to build in some fields that match by a date range.
Define some global date fields, gDate1, gDate2. Global storate is an option you can specify on the Storage tab in Field Options. Global storage is not strictly necessary here, but it can be a better option if you Host your database over a network so that multiple users can access it.
Find the above relationship in Manage | Database | relationships and double click the relationship line so that you can select and add more pairs of match fields to your relationship to get:
Employees::EmployeeID = Referrals::EmployeeID AND
Employees::gDate1< Referrals::Date AND
Now, if you place the summary field from Referrals on your Employees layout, it will report the count of all records that match this relationship.
And if you already have a different relaltionship between Employees and Referrals that you don't want to change, you can create a new occurrence of Referrals to use in this relationship and the reference to the summary field.
Thank You for the suggestion. I'm still used to spreadsheets and am just starting to wrap my head around relationships. I'll give it a shot tomorrow!