I am working with Access 365 and am having a difficult time trying to do a partial search for some data in my query. I am using Query Design to try and pull up data without having to know the entire name of the Agency or Business. I have tried entering: Like "*" & [Enter all or part of business name:] & "* for my search criteria, but it keeps changing Like to ALike and when I enter the first word of a business name that I know is in the table it returns nothing.
Any guidance would be greatly appreciated.
Thank you in advance.
DaKetch