simple update prob...

[mjonson]

hi,

i want to update the field 'dateassess' in table 'tbl_risk'
with the value 01/10/2004 where 'tbl_risk'.'siteid' = 2

UPDATE tbl_risk.dateassess = '01/10/2004'
WHERE (tbl_risk.siteid) = 2;

can you tell me where i am goin wrong?

 

[Golom]

You need

UPDATE tbl_risk 

SET tbl_risk.dateassess = #01/10/2004#

WHERE (tbl_risk.siteid) = 2;

Assuming that "dateassess" is a datetime field type. If it is a text field then leave the quotes as you had them.

 

[mordja]

mjonson,

UPDATE tbl_risk SET dateassess = #01/10/2004#
WHERE (tbl_risk.siteid) = 2;

MOrdja

 

[mjonson]

thanks v much