Updating a boolean field

[Maldrid]

Updating a boolean field [Resolved]

Anyone know why this does not work?

sSQLQuery = "UPDATE BackOutBilling SET Report = " & True & " WHERE [KitchenID] = '" & sKitchen _
        & "' AND [Report] = " & False

The field Report is set up as a yes/no field.

 

[Nouba]

You could try this one

sSQLQuery = sSQLQuery & "UPDATE BackOutBilling" & vbCrLf
sSQLQuery = sSQLQuery & "SET Report = True" & vbCrLf
sSQLQuery = sSQLQuery & "WHERE" & vbCrLf
sSQLQuery = sSQLQuery & "  KitchenID = '" & sKitchen & "' AND" & vbCrLf
sSQLQuery = sSQLQuery & "  Report = False" & vbCrLf

' check it in an empty query by copying the query out of the immediate window
Debug.Print sSQLQuery

KitchenID should in this case be a textfield.

 

[dcx693]

Don't forget to put some spaces in between words in your SQL clause, though.


sSQLQuery = "UPDATE BackOutBilling SET [Report] = True WHERE [KitchenID] = '" & sKitchen & "' AND [Report] = False;"

 

[Maldrid]

Thanks for the replies guys. I got it to work. Thanks for the help!!