
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 05, 2021 11:36 AM
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?
1 Reply 1

Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 05, 2021 01:48 PM
EDIT
I did this in the end using a COUNT field with a CONDITION
