Query and CAPS question

[Thant]

I am trying to run a query using two tables with common information (medication names) in “text” format. The field in one of the tables is in all CAPITAL letters; the field in the other table has a mix of Upper and lowercase letters. I believe my query is returning no results because of the CAPS mismatch. An Access expert once told me that there was a way to get it to ignore the capitalization but I can’t find it. Please help!
Thanks

 

[PHV]

Use a condition like this:
[one of the tables].[medication names] = UCase([the other table].[medication names])

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886