User Support Forum

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

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.

That worked. Thank you!