Prev: Controlling decimal digits
Next: Need a database for horse racing
From: De Jager on 13 Mar 2010 12:58

"Sue" <labessade(a)dsl.pipex.com> wrote in message
news:%238W02STuKHA.4908(a)TK2MSFTNGP06.phx.gbl...
> Hi all
>
> I had an update sql statement working setting a value to true (boolean
> field) on a set condition, but I am now trying to update a 2nd field also
> which is text type and I can't seem to get the syntax right. I get
> 'expected end of statement' message. Code is:
>
> strSQL = "UPDATE [qry Resource Planning VVs] " & _
> "SET [Selected] = True & _
> "[Activity] = '"VV"', " & _
> "WHERE Territory_Code = " & """" & txtTerritory & """"
>
> Can anyone please help correct this? Thanks...
>

From: joelgeraldine on 17 Mar 2010 09:49
kjkjkjk

"Sue" <labessade(a)dsl.pipex.com> a �crit dans le message de groupe de
discussion : #8W02STuKHA.4908(a)TK2MSFTNGP06.phx.gbl...
> Hi all
>
> I had an update sql statement working setting a value to true (boolean
> field) on a set condition, but I am now trying to update a 2nd field also
> which is text type and I can't seem to get the syntax right. I get
> 'expected end of statement' message. Code is:
>
> strSQL = "UPDATE [qry Resource Planning VVs] " & _
> "SET [Selected] = True & _
> "[Activity] = '"VV"', " & _
> "WHERE Territory_Code = " & """" & txtTerritory & """"
>
> Can anyone please help correct this? Thanks...
>
First  |  Prev  | 
Pages: 1 2
Prev: Controlling decimal digits
Next: Need a database for horse racing