Joe Hecht
jmhla at earthlink.net
Tue Dec 21 22:09:58 CST 2004
Susan, You win my hero of this problem. Thanks JOE HECHT LOS ANGELES CA jmhla at earthlink.net -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins Sent: Tuesday, December 21, 2004 7:49 PM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Select query to append query problem x posted Run the SELECT without the DISTINCT keyword and see what you get. Susan H. 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com