Uique Values (1 Viewer)

Hi please help

I am creating a report to show all the students a member of staff has enrolled at any particular time.

I need the student information to be unique so the report is based on a query using the student information table and the enrolment table which records the date enrolled and by whom. I used the 'Unique Values' in the query property sheet but it is not working.

The issue maybe that the enrolment dates are different but I thought that 'Unique Value' only worked on the fields selected for the query?

Thank you

http://www.fmsinc.com/microsoftaccess/query/distinct_vs_distinctrow/unique_values_records.asp

Any chance you selected distinct rows not distinct values?