Custom Attendance Report
Posted: Sat Mar 22, 2008 9:49 am
I've created a custom attendance report which shows the profile's name and the last date they attended worship (max date for the activity).
Is there a way to use max(date) in the selection criteria? I would like to create the report where the last date attended was before 1/1/2007. My current criteria are:
Skill number equal to 1 and
Attendance Status begins with "P"
If I add: and date < 1/1/2007 any records after that date are ignored.
I want to add to the query: and max(date) < 1/1/2007.
Is this possible? The menu driven coding doesn't seem to let you use a function as selection criteria.
Blessings,
Carol Brown
Is there a way to use max(date) in the selection criteria? I would like to create the report where the last date attended was before 1/1/2007. My current criteria are:
Skill number equal to 1 and
Attendance Status begins with "P"
If I add: and date < 1/1/2007 any records after that date are ignored.
I want to add to the query: and max(date) < 1/1/2007.
Is this possible? The menu driven coding doesn't seem to let you use a function as selection criteria.
Blessings,
Carol Brown