Date Last Attended

Postby smaybury » Thu Jul 11, 2019 6:12 pm

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?
smaybury
 
Posts: 1
Joined: Fri Jan 25, 2019 9:03 pm

Re: Date Last Attended

Postby NeilZ » Thu Jul 11, 2019 10:26 pm

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.
NeilZ
 
Posts: 8905
Joined: Wed Oct 08, 2003 12:20 am
Location: Connellsville, PA