Fred Hooper
fahooper at trapo.com
Wed Jan 23 14:07:15 CST 2008
How about something like this: DoCmd.RunSQL "INSERT INTO tEvictionCasesTemp1 ( UDCaseID, Note ) " & _ "SELECT [" & RS(0) & "], [" & RS(10) & "] FROM <some table>" -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at Beach Access Software Sent: Wednesday, January 23, 2008 2:08 PM To: 'Access Developers discussion and problem solving' Subject: [AccessD] SQL INSERT Question I have a client who write a lot of his own stuff. Right now he's trying to insert into an Access table memo field using the following: DoCmd.RunSQL "INSERT INTO tEvictionCasesTemp1 ( UDCaseID, Note ) " & _ "SELECT " & RS(0) & ", '" & RS(10) & "'" which generates the error: "Syntax error in INSERT INTO statement" RA(n) are the fields in a recordset hooked to SQL database. The fields RS(0) and RS(10) contain god data (he checked) with no embedded quotes or apostrophes. Although he says that he needs to be able to The target field Note is a memo field in the Access table. RS(0) has already been successfully inserted into tEvictionCasesTemp1. What might be causing the syntax error? MTIA Rocky -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com