How to filter by count value in my Form-Based-Query that generates a Report.

[Xine]

I do the admin for a employee volunteer program.
I created a User Form that can filter the program information based on company, office location, and/or employment status (and generates a report).


I'd like to allow the user the option of filtering by the number of years an employee has participated in this program.
Since there isn't a field that has this (count) value stored, I tried adding a count field to the query but it doesn't work properly on account of there being other unfiltered data details that are included for the report.

I'm clearly going about this the wrong way. Should I somehow filter the report instead of the query? Direction with examples would be appreciate

[ranman256]

the # years, is a date formula
=DateDiff("yyyy",[startdate],Date())

[Xine]

The (program) year is better described as an event occurrence rather than a passage of time:

Some employees have never participated, others have a spotty history of participation while a few have participated every year since the program was offered in 2003.

I'm not sure but I don't think I can use a DateDiff here, no?