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