Page 1 of 1

Date Last Attended

PostPosted: Thu Jul 11, 2019 6:12 pm
by smaybury
I have created a custom weekly absentee report for my Pastor. I would like to include the last date attended. I'm not sure how to create the query for that date. Can you help?

Re: Date Last Attended

PostPosted: Thu Jul 11, 2019 10:26 pm
by NeilZ
smaybury wrote:I have created a custom weekly absentee report for my Pastor. I would like to include the last date attended. I'm not sure how to create the query for that date. Can you help?


First off, getting the 'absentees' for a specific date is easy, what you want to do involves reading the database and finding the 'greatest date' for each attendee.

That said, I think you're reinventing the wheel. Have you looked at the standard Consecutive Absentee Report? You can adjust the filters to pull by a single date. It also can include or exclude the display of addresses, email addresses, and phones.