Date Last Attended
Moderators: Moderators, Tech Support
Date Last Attended
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
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.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?
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.
Neil Zampella
Using PC+ since 1999.
Using PC+ since 1999.