Runtime error '3075'

[aganesan99]

Hi All,

I am getting "Run-time error '3075'" syntax (missing operator) in query expression

'((([GRN_Account Details].[WBS Element]) Is Null Or (([GRN_Account Details].[WBS Element])="") " & _
OR (((Left([GRN_Account Details].[WBS Element],4))=""GB.9""));'

while executing the following code:

DoCmd.RunSQL ("UPDATE [GRN_Account Details] SET [GRN_Account Details].[Customer Name] = ""Non Customer"", " & _
"[GRN_Account Details].[WBS Name] = ""Non Customer"", [GRN_Account Details].Market = ""Service Line"", " & _
"[GRN_Account Details].[Sub Market] = [GRN_Account Details].[SL]" & _
"WHERE ((([GRN_Account Details].[WBS Element]) Is Null Or (([GRN_Account Details].[WBS Element])="") OR " & _
"(((Left([GRN_Account Details].[WBS Element],4))=""GB.9""));")

I am unable to identify what causes the error.:banghead:

Any help appreciated.

Thanks in advance

Regards,
aganesan99

 

[plog]

What does your SQL statement actually resolve to? You're building a string, find out what the string says exactly.

My initial guess is that there's no space before the WHERE. But, you really need to find out what your SQL actually says. As it is now you are trying to debug it one layer up from where it actually lives.

 

[pbaldy]

Agree, and here's how:

http://www.baldyweb.com/ImmediateWindow.htm

 

[aganesan99]

Thanks plog and pbaldy

It worked.

Thank you very much