This isn't really a visual basic question, and it's probably really easy, but how can you run a query in Access for fields with an asterisk (*) in it. It keeps treating * as a wildcard and giving me the entire table.
Printable View
This isn't really a visual basic question, and it's probably really easy, but how can you run a query in Access for fields with an asterisk (*) in it. It keeps treating * as a wildcard and giving me the entire table.
Wrap the asterisk in square brackets.
Like "[*]*" - Starts with *
Like "*[*]*" - Contains a *
Like "*[*]" - Ends with *
haha i knew it was something simple.
Thanks dude.