Actually, I think I've identified the problem.
I think it's my use of wildcards.
Whenever I use wildcards (ie. Like "*" & [field] & "*"), it returns any occurrence of the pattern I'm looking for, which is what I want, but if I leave that field blank, it returns every record, which is what I...