Values identical, yet my query returns Mismatch! HELP

[wuhsean22]

Hi friends,


i have the following query:

iif([PC]=[WIP PC],"True", False")


And in my dataset, PC= UGZA6LK0 and WIP PC =UGZA6LK0. I confirmed both values are TEXT format and I trimmed off any spaces. Why is this still returning as FALSE. There are other values that are identical that are returning TRUE.

puzzled..Sean

tHanks in advance!

[qa12dx]

iif([PC]=[WIP PC],"True", False")

u forgot the quotation marks infront of false

iif([PC]=[WIP PC],"True", "False")

[recyan]

I once faced this problem, when the data entry was done as O instead of 0 and vice-versa in an excel sheet & without my specs it took me some time to realize what had happened.