Forum Discussion
DonLarson
Qrew Commander
Do you need a total for all time or will you have to specify specific periods?
For a small number of records in the People table I think I have a solution. If there are thousands of People than a solution is in order.
HarrisonSmith
15 days agoQrew Trainee
There's ~150 people, so relatively few
- HarrisonSmith15 days agoQrew Trainee
a total for all time. I have a calc start & end formula date fields that put a cap on the timeframe if the provided date ranges exceed the relevant timeframe. There are currently 100 claimants, 210 residence records, and 40 employment records, knowing that will increase in the future, but it shouldn't get into the 1000's.