I currently am able to use ADO to query Access and pull the data I need, but am not able to return the data when attempting to use wildcards. If I have values in E1 and H1 then the query returns the proper information, but if I attempt to replace either with either blank,*, % or # no data is returned. I was hoping someone might know how to incorporate wildcards so that data will be returned if one or two are used when passing values. Thanks for the help.

Please Login or Register  to view this content.
In case it is of importance, dtype is a dropdown that determines which table to search and the others are stored as text in Access.