[AccessD] Select query to append query problem x posted

Joe Hecht jmhla at earthlink.net
Tue Dec 21 21:34:58 CST 2004


I have a select query which properly returns 3 records.

SELECT DISTINCT JobDoc.DocID, stblEmpJobTitle.EmpID
FROM JobDoc INNER JOIN stblEmpJobTitle ON JobDoc.JobTitleID =
stblEmpJobTitle.JobTitleID
WHERE (((JobDoc.DocID)=[Forms]![JobDocSort]![DocID]) AND
((JobDoc.JobTitleID)=[Forms]![JobDocSort]![JobTitleID]));

When I run the same query as an append query it adds 14 records. 

INSERT INTO TrainDate ( DocID, EmpID )
SELECT DISTINCT JobDoc.DocID, stblEmpJobTitle.EmpID
FROM JobDoc INNER JOIN stblEmpJobTitle ON JobDoc.JobTitleID =
stblEmpJobTitle.JobTitleID
WHERE (((JobDoc.DocID)=[Forms]![JobDocSort]![DocID]) AND
((JobDoc.JobTitleID)=[Forms]![JobDocSort]![JobTitleID]));

The extra records do not seem to have any common link.

JOE HECHT
LOS ANGELES CA 
 jmhla at earthlink.net






More information about the AccessD mailing list