How to determine if two similar fields match from two separate tables in a single query

[ATTHECROSS]

Hello -

I am trying to get a "True" "False" output from running an exact match on two similar fields from two different tables. I have the two fields side by side in a single query with a third field that is established to return the values of "True" or "False" if they match/don't match.



I need help knowing how to do this in an Access query. In Excel I just use an exact match formula.

Thanks for the help

[JoeM]

Are your two tables joined in a one-to-one relationship?

If so, then you should just be able to create a Calculated field like this:

Check: IIF([Table1].[Field1]=[Table2].[Field1],True,False)

[ATTHECROSS]

JoeM -

Thanks for the help! That worked great! The only tweek I had to do was to add quotes around the "True" and "False".

[JoeM]

Thanks for the help! That worked great! The only tweek I had to do was to add quotes around the "True" and "False".

You are welcome!

Note that when you place double-quotes around "True" and "False", that returns text values.
If you leave them off, it will return boolean values.

Choose whichever one is appropriate (note that if you were working with a Boolean "Yes/No", "True/False", or CheckBox field, you would use Boolean values, not text).
However, if you are just returning a value to a screen in a query, it probably doesn't matter.