How to capture the date (or date/time) a summary field reaches a certain number

I am trying to capture the date that an agent reaches their commission cap so that commission formulas change after that date. I have two tables: Agents and Transactions - Agents is the parent table a...