Simple SQL generating an error (3075) 1

[braidj]

Got a simple piece of SQL to run from VBA

DoCmd.RunSQL ("UPDATE tblAccountDetails " _
& "SET Flip_SFA = 'Y' " _
& "FROM tblAccountDetails,tblFlipOnBalance " _
& "WHERE tblAccountDetails.Original_SFA = tblFlipOnBalance.SFA_Category&quot

The sql runs in via other tools succesfully but ACCESS does n't like it.
I know its something to do with syntax on the fields, any one got any ideas as its really frustrating.

TIA

Jason

 

[Alcar]

A trick I use, seems strange but works most of the time, is to assign the string to a string variable and then run the variable through the command...

This will help you to have a better view of your string. Another thing, try to use the double "" instead of the single '

That might also help. I presume that the names of the fields are correct.

HTH
Alcar