JoeM... I had one more question after your help from yesterday

[ATTHECROSS]

JoeM -



Since I already clicked "solved" I couldn't reply to ask you another question about my original post. Yesterday I asked about the code for obtaining an output of "true" "false" from two tables in one query and you provided the code...Check: IIF([Table1].[Field1]=[Table2].[Field1],True,False. It worked great, as I said, except when both "Field1" and "Field2" from their respective tables are both BLANK the value of "FALSE" is returned when it should be "true". I checked to make sure that the data was correctly scrubbed so that there weren't any hidden spaces or other issues and the data is good to go. I even tried it as the boolean values as you suggested and I still get a "0" for the instances where both fields are blank.

Any thoughts on how to fix this? Thanks for the help

[JoeM]

Access does not really like null values. A null value is not equal to another null value.
The key is to use the Nz function, which converts a Null value to a value of your choosing.

So, try something like:

IIF(Nz([Table1].[Field1],"Empty")=Nz([Table2].[Field1],"Empty"),True,False)

By the way, I think you can still post to that other thread. It isn't locked out or anything. The "Solved" is just a flag to let people know at a glance that it has been solved.
But you can still reply to it, and I will see those.

[kd2017]

IIF( ([Table1].[Field1] = [Table2].[Field1]) OR ([Table1].[Field1] Is Null AND [Table2].[Field1] Is Null) , True, False)

[ATTHECROSS]

JoeM -

Thank you for the help! Really appreciate it! Worked perfectly. Have a good one

[JoeM]

You are welcome.