Consecutive Absentee Reports
Posted: Tue Nov 29, 2016 3:08 pm
We need a list of people who have been missing from the church for 3 consecutive weeks. The problem is that there seems to be no way of running this report across the board. For example: a couple comes to a Wednesday night activity every week but not Sunday services. They come to Sunday Services 1 week and then 3 weeks later end up on the consecutive absentee report. Is there a way to make a custom report that would show you if they had not been in "ANY" activity for 3 weeks instead of if they have been missing from just 1 activity for 3 weeks? It is currently giving a lot of false names. Thank you.
PS. I have already tried changing all activities to a single "Type" and running the report according to "Type". I am still getting people on my report who were marked present during the specified range of dates.
PS. I have already tried changing all activities to a single "Type" and running the report according to "Type". I am still getting people on my report who were marked present during the specified range of dates.