ACCESS Update Command Not Working

[cybersurfer]

Hi

Can someone please tell me why this following UPDATE command doesn't update the DB?

UPDATE tblTest SET tblTest.Answer1 = '92107933' AND tblTest.Answer2='2006-12-17'
WHERE ID=1;

The Answer1 and Answer2 fields are configured as Text. This update command doesn't work, but this one does.

UPDATE tblTest SET tblTest.TimeStarted ='16:18:18.2820743' WHERE ID = 1

What am I doing wrong? Is is because I'm trying to set 2 fields in the first query and only 1 in the second query?

Pls Help?

Tanks

[ADezii]

Hi

Can someone please tell me why this following UPDATE command doesn't update the DB?
UPDATE tblTest SET tblTest.Answer1 = '92107933' AND tblTest.Answer2='2006-12-17'
WHERE ID=1;

The Answer1 and Answer2 fields are configured as Text. This update command doesn't work, but this one does.

UPDATE tblTest SET tblTest.TimeStarted ='16:18:18.2820743' WHERE ID = 1

What am I doing wrong? Is is because I'm trying to set 2 fields in the first query and only 1 in the second query?

Pls Help?

Tanks

It's simply a matter of Syntax, drop the AND and place a comma between multiple Fields in the Update Statement. Hope this helps.

Dim MySQL As String
 
MySQL = "UPDATE tblTest SET tblTest.Answer1 = '92107933', tblTest.Answer2 = '2006-12-17' WHERE ((([tblTest].[ID])=1));"
 
DoCmd.RunSQL MySQL