Using XP, PCP v. 9, I am creating a custom attendance report. The output is not recognizing the date that I am entering (below). It is pulling all dates since the inception of our using PCP.
RECORD FILTER:
Date is greater than or equal to August 3, 2008 and
Skill Number is equal to 1001 and
Person Status Code exactly matches Child Participating or
PSC exactly matches Child of NonParticp Membr or
PSC (ditto) Particp NonMember or
PSC (ditto) Particp Member - Resident or
PSC (ditto) Visitor
OUTPUT FIELDS:
Last Name, First Name
Family Phone 1
Date
Attendance Status
Personal Status Desc
Thanks for any assistance you can provide.
Becky
Custom Attendance Report - Not getting requested date result
Moderators: Moderators, Tech Support
-
- Tech Support
- Posts: 3015
- Joined: Thu May 13, 2004 9:59 am
- Location: PowerChurch Software
- Contact:
The query will need brackets to close in all of the personal status code selections, like this:
Date is greater than or equal to August 3, 2008 and
Skill Number is equal to 1001 and
( Person Status Code exactly matches Child Participating or
PSC exactly matches Child of NonParticp Membr or
PSC (ditto) Particp NonMember or
PSC (ditto) Particp Member - Resident or
PSC (ditto) Visitor )
You can add brackets by going to Edit Record Filter, selecting the first of the Personal Status Code query conditions, click the Brackets() button, then select the last of the query conditions.
Date is greater than or equal to August 3, 2008 and
Skill Number is equal to 1001 and
( Person Status Code exactly matches Child Participating or
PSC exactly matches Child of NonParticp Membr or
PSC (ditto) Particp NonMember or
PSC (ditto) Particp Member - Resident or
PSC (ditto) Visitor )
You can add brackets by going to Edit Record Filter, selecting the first of the Personal Status Code query conditions, click the Brackets() button, then select the last of the query conditions.