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
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