I have a date field that is capturing day, month and year. For certain reporting, I am needing to look at that date in the format of year. I can format it as yyyy and get a result of 2001, 2002, etc., but when I try to make a drop down list of just years so I can open a report with only classes attended during the year chosen, I am getting an error telling me my field type is not valid. In addition, in my query that is supposed to group the dates to return a particular year, I am grouping and asking for unique values but I still get a record for each full date entered though it is only returning the year. There are no other fields in this query except for year. I was hoping to get a grouped list of only one listing per year so the user would have a dropdown option to filter the report. Am I looking at this all wrong?

The user enters the class completed date against one of several classes. The attendee can attend multiple classes, and certain classes are up for renewal each year, others every 2 years. The user wants to be able to pull reports to see who is up for renewal, and to look at an entire year and see everything everyone attended for that year. What is the best way I can accomplish this? There are 3 tables, one with complete attendee information, name, address, etc. The 2nd is for class types, the 3rd is to post the actual dates and choose the class type from drop down list tied to table 2. Appreciate any help, thank you.