 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / April 2007Wild Card Doesn't Work ANymore
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 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.  SignatureRegards Jeff Boyce Microsoft Office/Access MVP http://mvp.support.microsoft.com/ Microsoft IT Academy Program Mentor http://microsoftitacademy.com/ Microsoft Registered Partner https://partner.microsoft.com/ > 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 [quoted text clipped - 10 lines] > > Matt Jeff, Yes, when I type in the whole name "Smith", all of the Smiths are displayed. So, the query is working. > 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. [quoted text clipped - 14 lines] > > > > Matt 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 > Jeff, > [quoted text clipped - 24 lines] >> > >> > Matt |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.