Wild Card Doesn't Work ANymore

[mjaeky]

I have been using Access for a few years and successfully using the wild card
"*" with my searches in a query. For the past week or so, the wild card
query doesn't return results on searches.

For example, in a Last Name query, I'd type in the query box Smit* and all
of the last names of Smith, for example, would be displayed.

Lately, no last names are displayed. A blank result is returned. I've
repaired the installation and reinstalled the installation and nothing can
correct the problem.

Any suggestions?

Matt

 

[Jeff Boyce]

The first step I'd take is to create a new query, put in "Smith" for a
criterion, and make sure the table has "Smith"s and the query is working.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

 

[mjaeky]

Jeff,

Yes, when I type in the whole name "Smith", all of the Smiths are displayed.
So, the query is working.

 

[Michel Walsh]

It may be that you have changed some option setting and now, you have the
ANSI (Unix-like) wildcard, _ and %, rather than the DOS wildcard , ? and *.

You are using LIKE, not =, I assume, sure. So, try if "Smith%" works, when
"Smith*" does not.



Vanderghast, Access MVP