This should have been easy, but it's got me stymied. I need to create a sign-in system that will allow me to track participant attendance at the 1 month, 3 month, and 6 month points, and I'm stymied.
At the moment, I have the participant signing in with first name, last name, and the DB automatically generates the date. I can count the number of weeks since the participant first showed up, but I also need to count the number of times in that period that they've signed in.
So if I have the following entries:
... how can I calculate that Jim Kirk has signed in 3 times in the last month?