Brackets being put around Where in SQL line 1

[TBOB]

I'm building an SQL string based on a selection from an option group. When I look at the string in VBA it looks like this: "SELECT RCLSITES.*FROM RCLSITES WHERE rcllink = ZNY". The query doesn't run, but asks for a parameter. When I look at the query something has added brackets around [ZNY]. If I strip off the brackets I get the desired result. Where do I need to look to correct this problem?

Thanks,

Tony

 

[r937]

it thinks ZNY is a column

if you meant a string, you havbe to put quotes around it

... WHERE rcllink = 'ZNY'

rudy

http://r937.com/

SQL Consulting

 

[TBOB]

r937,

That was it. Thanks.

Tony