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