Double data in Query

Hi,
Am trying to create a query using two tables. One is a list of student
names and id number and one is a list of courses. Using the id number as a
reference, i need to extract the employee's id and see what course he/she
completed or not. Unfortunatly, in my query results i get as many times
(lines) as number of courses the employee has followed. How can i avoid that
and have only a single record (line) with student id, course number and an
"X" if that course has been followed (null if not followed). Thanks!

If I understand the problem correctly, use your current query as the basis
for a crosstab query when using the Crosstab Query Wizard.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

"Nancy" wrote:

Hi,
Am trying to create a query using two tables. One is a list of student
names and id number and one is a list of courses. Using the id number as a
reference, i need to extract the employee's id and see what course he/she
completed or not. Unfortunatly, in my query results i get as many times
(lines) as number of courses the employee has followed. How can i avoid that
and have only a single record (line) with student id, course number and an
"X" if that course has been followed (null if not followed). Thanks!