[thelist] Updating two fields with SQL

Rudy_Limeback at maritimelife.ca Rudy_Limeback at maritimelife.ca
Mon Aug 21 12:52:04 CDT 2000


>   UPDATE TableName
>   SET    FirstField='New Value 1'
>   AND    SecondField='New Value 2'
>   WHERE  ID='#form.ID#'

hi minh lee

ms access autonumbers should not have quotes

but that's not what's causing your error

change it to

   UPDATE TableName
   SET    FirstField='New Value 1'
        , SecondField='New Value 2'
   WHERE  ID='#form.ID#'


rudy limeback
r937.com
evolt.org





More information about the thelist mailing list