I am building a gym membership system.
People pay for X visits which they can use in a 30 day period.
When they arrive, they check in (which adds a record).

I want to count the number of records for a member (COUNTALL)…
…but I only want to see how many records in the last 30 days.

Blaggin my head trying to work out how I can do it.
Any ideas?