VBA SQL if Statement

[popfan]

I am trying to test 2 sql statements to see which has a value first and put it onto the worksheet

Please Login or Register  to view this content.

The main problem is that sSQL sometimes has no matches and there is null, but for some reason the if statement doesn't work at all. either that or the rs.fields(0).value doesn't even exist so it cannot even be null.

[tlafferty]

See what value the variable contains by sending it to a message box on the one before your if statement:

Please Login or Register  to view this content.

[popfan]

The value for the if part doesn't seem to work. It continues to come back as '0' and does not update to the new SQL statement.

And the message box value doesn't return if the SQL statement doesn't find anything.

I also tried the following:

Please Login or Register  to view this content.

[popfan]

Just tried one more thing:

Please Login or Register  to view this content.

I don't even get the msgbox back

[popfan]

I tried running both SQL scripts without any if statements and seems that the first SQL script cannot be over written by the second script.

[popfan]

Would it be easier to create a second function and call each one individually and do the if then checks in the second function?