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")

..
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Comparing Possible Like Records 5
compare field in one table to several fields in another table & al 4
Excel Comparing two columns 1
Query that will look for duplicate in two tables. 3
Compare data that do not exactly match 3
comparing two tables with the same field 10
Compare mulitple fields in two tables 7
Compare two columns in same table; result in 3 column 4

Back
Top