Custom Attendance Report

[Carol@bethel]

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