Need help with referring back to previous records.
I have a calculation field, ActiveNumber = Count ( Clients|Active::_fkTrainerID ) which counts up the Clients that are Active. I am not sure that I can set this up but I run a report at the beginning of each month for the previous month. So if Trainer A has 55 Clients at the end of the previous month (April) and I happen to run this report at towards the middle of May, Trainer A might have already added 5 Clients. So instead of just showing 55 Clients for the previous month (April) it will now show 60 Clients. That will mess up the entire calculation that depends on the number of Clients Trainer A has for that previous month.
Is there a way for me to set it up to where if Trainer A has 55 clients at the end of the month no matter how many clients they add for months after it will still show 55 Clients if I refer back to that month?