Sum Overlapping Time/Remove Timeframe Gaps
Hi all, is there a way to do this formula queries? I have a table of people who have child residence & employment records, with start & end dates for each, as well as a numeric field that summarizes ...
Forum Discussion
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.
There's ~150 people, so relatively few
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.
