I am working on a access database that is linked to an Excel table. I am finding that a search criteria in a query in this database has become case sensitive. How can I change it to be not case sensitive? Thanks in advance for any help.
Results 1 to 2 of 2
Thread: Queries Case Sensitive (2002)
-
2 Star Lounger
- Join Date
- May 2002
- Posts
- 113
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2002-12-12 00:13Queries Case Sensitive (2002)
-
Subscribe to get a FREE chapter from Windows 7 The Missing Manual
This month, every Windows Secrets subscriber can download a one-chapter excerpt of Windows 7: The Missing Manual.Windows 7: The Missing Manual provides valuable information to help you overcome these difficulties in learning a new operating system. Subscribe today to download your free excerpt.
-
Plutonium Lounger
- Join Date
- Dec 2000
- Location
- Sacramento, California, USA
- Posts
- 16,775
- Thanks
- 0
- Thanked 1 Time in 1 Post
2002-12-12 03:55Re: Queries Case Sensitive (2002)
Access itself is not case sensitive, so you must have changed something. And what do you mean by the search criteria being case sensitive? Are you using a form or how are you "searching" in the query?
Charlotte
