Date Last Attended

Moderators: Moderators, Tech Support

Post Reply
smaybury
Posts: 1
Joined: Fri Jan 25, 2019 9:03 pm

Date Last Attended

Post 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?

NeilZ
Posts: 10209
Joined: Wed Oct 08, 2003 1:20 am
Location: Dexter NM
Contact:

Re: Date Last Attended

Post 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.
Neil Zampella

Using PC+ since 1999.

Post Reply