why doesnt this work

[ice-9]

I have to tables.
one dummy and one main. The have the same fields.
the dummy is filled by a form.
i want to see where they are diffrent. But the query shows all the dummys records. I just want it to show the record that doesnt exists in the main table.


SELECT DISTINCT AttendenceDummy.MeetingCode, AttendenceDummy.EmployeeCode
FROM Attendance INNER JOIN AttendenceDummy ON Attendance.MeetingCode = AttendenceDummy.MeetingCode
WHERE (((AttendenceDummy.EmployeeCode)<>Exists (select Attendance.EmployeeCode from Attendance )));

 

[neileg]

A number of problems here. Quickest solution would be to use the unmatched record wizard in Access.

 

[raskew]

Hi -

Take a look at this thread http://www.access-programmers.co.uk/forums/showthread.php?t=93166

HTH - Bob