E
ercjfk
I've created a query that lists the student ids for students who were
enrolled in particular courses (along with some other data). However, some
students are enrolled in more than one course so the query contains some
dulicate student ids. I want to get rid of the duplicated student ids so that
each student appears in the list just once.
I tried creating another query to count the values in the column, but I
don't have the option to select "Count Distinct" in the totals row as the
Access Help suggested. Any ideas?
enrolled in particular courses (along with some other data). However, some
students are enrolled in more than one course so the query contains some
dulicate student ids. I want to get rid of the duplicated student ids so that
each student appears in the list just once.
I tried creating another query to count the values in the column, but I
don't have the option to select "Count Distinct" in the totals row as the
Access Help suggested. Any ideas?