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?