Treat empty variable - Excel VBA

[Alvim]

Dear,

I would like to know how to treat an empty variable in an expression that sql query a table access 2007.

I've read some articles about using the IS NULL and IS NOT NULL and made ​​a few unsuccessful attempts.

I tried and did not work well:

Please Login or Register  to view this content.

In my example, the variable3 is empty.

Anyone know how to say the words correctly write?

Sorry if I wrote it wrong.

At

[Norie]

Do you actually need variable3 in the SQL if it's empty?

If you don't you could try something like this.

Please Login or Register  to view this content.

[Alvim]

Do you actually need variable3 in the SQL if it's empty?

If you don't you could try something like this.

Please Login or Register  to view this content.

It was exactly that.

Thank you.

At

Alvim