Hello, I tried to write a query in MS Access with a criteria that displayed all the records that contained a string that was all CAPS. The criteria used was Ucase([Table1]![Field1]) but it still shows ALL the records. I guess MS Access' queries don't differentiate caps and non caps, is there a way to make this work?

Thanks,
Thai