Upper and lower case not matching

[marathonlady]

Where is the setting in access so the upper and lower case will match and I don't have to search on both in a query?

Any help is much appreciated!!

 

[GeoNelix]

In the query set the field your going to search on to either all upper case or all lower case using Ucase([FieldName])

 

[Pat Hartman]

You need to do this on BOTH sides of the equasion.

Where Ucase(....) = Ucase(....);