[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