Double data in Query

[Nancy]

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!

 

[Jerry Whittle]

If I understand the problem correctly, use your current query as the basis
for a crosstab query when using the Crosstab Query Wizard.