Link to home
Avatar of thandel
thandel

asked on

SQL Update Syntax

Would like to update all the values  in a table (tOffice) to False (-1) for the field name "Courier"

I've tried some variations of this SQL command without luck

DoCmd.RunSQL "UPDATE toffice SET Courier  =  -1

Courier is a yes/no variable.

What is wrong with my syntax?  Should I be using an SQL update for this?
ASKER CERTIFIED SOLUTION
Avatar of Raja Jegan R
Raja Jegan R
Flag of India image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Avatar of thandel
thandel

ASKER

Thanks!
No problem, by the way you can actually use No/False.
DoCmd.RunSQL "UPDATE toffice SET Courier  =  No"

Open in new window


DoCmd.RunSQL "UPDATE toffice SET Courier  =  False"

Open in new window