Compare two table fields for EXACT match

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two legacy tables from different sources with customer names and need
to compare the names in the two tables to determine exact legal name matches
and differences. How do I apply the excel "EXACT" logic function to the
fields and determine results of "TRUE" or "FALSE" or do is there another way
to accomplish the test?

In short
tbl.one legal name tbltwo.legal name = field 3 TRUE or FALSE.

Thank you.
Quan
 
Depends where you are doing the comaprison and if you want the fields
displayed. For example

The field in the query grid would be
tbl.one legal name = tbltwo.legal name

and the criteria would be = TRUE

or in a form / query use an IIF
=iif(tbl.one legal name = tbltwo.legal name, "Match","Do not match")

..
 
Back
Top