Lower case

  • Thread starter Thread starter Aaron Neunz
  • Start date Start date
A

Aaron Neunz

Say I have upper and lower case X's. I only would like to filter on lower
case x's. How might I accomplish this?


Thanks,
Aaron Neunz
 
Say I have upper and lower case X's. I only would like to filter on lower
case x's. How might I accomplish this?


Thanks,
Aaron Neunz
Click to expand...

Not terribly easily. Access is inherently insensitive to case.

You can use the StrComp() function to distinguish fields by case. For
instance, if you have a one-character field which might contain a, A,
x, or X (or any other single letter) and you want to find all
instances where it contains a lowercase x, use a query criterion of

="x" AND StrComp([fieldname], "x", 0) = 0

The ="x" criterion by itself will retrieve both x and X (but will use
any index on the field and limit the calls to the StrComp function to
just x and X); StrComp will provide the case sensitivity.

See the online help for StrComp in the VBA editor's help file for more
info.

John W. Vinson[MVP]
 
Say I have upper and lower case X's. I only would like to filter on lower
case x's. How might I accomplish this?
Click to expand...
if its only one letter you can use ASC("x")=120
 
Back
Top