Thanks for responding Neil. That is generally how I would handle it too. But
this customer actually wants the two versions and wants to separate them in the
query. For some reason the one with the caps and the one with the lower case is
actually a different value to them. So they need to know how many of each they
have.
From: Neil Ives neil.i...@gmail.com
To: ms_access@yahoogroups.com
Sent: Mon, July 12, 2010 4:45:30 AM
Subject: Re: [ms_access] Query criteria by upper of lower case
Lonnie,
The way I do this in code is to use 'Ucase' to force the string into
uppercase when checking against the same string in upper case:
If Ucase(Mystring) = ACTUALS then [do something]
Alternativeley you could convert all user input into upper case when
first entered. In Access the data tables and forms can be set to force
input into Upper case.
Neil Ives
On 11 July 2010 23:51, Lonnie Johnson prode...@yahoo.com wrote:
Just curious,
Is there a way to search or match a string that is just upper case or mixed
case? I have a filed that has these two values and the customer actually wants
to be able search for just one of the two. The two values are...
2010 ACTUALS
2010 Actuals
[Non-text portions of this message have been removed]
Yahoo! Groups Links
--
Neil Ives
[Non-text portions of this message have been removed]
