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?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
No problem, by the way you can actually use No/False.
DoCmd.RunSQL "UPDATE toffice SET Courier = No"
DoCmd.RunSQL "UPDATE toffice SET Courier = False"
ASKER