Access does not support % as a wildcard character. It does, in fact, support the * character, as well as a few others. From MS Access help:
* Matches any number of characters. It can be used as the first or last character in the character string. wh* finds what, white, and why
? Matches any...