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