If this fails, please try one more time of hardcoding it with the following statement:

"SELECT * FROM Addresses WHERE Zip LIKE '91%'"

And let me know if that returns anything as well.


Hi guys

I did some googling and tried to find out things about wildcards.

It might work (just might) if changing this wildcard (%) to this wildcard (*). Depends on what database in use. Some "sources" says that this one is for Access and the (%) is SQL servers. I don't now for sure but it is worth trying if the last hint doesn't work.

' " & izip & " * ' "

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.