easy SQL question 1

[jimb0ne]

I'm sql dumb, I'm trying to open a report based on a query which is based on a couple of tables. the wherecondition I'm trying to pass with the openreport method is the following:

Unit = "Audiology" OR ExtraUnit1 = "Audiology" OR ExtraUnit2 = "Audiology";

I keep getting a syntax error when I try to open the report, could someone let me know where I fudged?

thanks,
Jimb0ne

 

[glalsop]

Do you have the entire WHERE parameter wrapped in double-quotes?

"( (Unit = 'Audiology') OR (ExtraUnit1 = 'Audiology') OR (ExtraUnit2 = 'Audiology') )"

-Gary

 

[jimb0ne]

thanks dood, that was it.