Duane, sort of.  Essentially I have 6 tables, 3 for each query.  Data for the
transactions are entered through a form which populates multiple Access
tables.  I then take this data and enter it into another system, which behind
the scenes populates mainframe tables.  It is a very ineffficient way of
doing things, but it is what it is.

I am attempting to do the following.  I have one query that pull in all the
data from the Access Tables, and a separate query that pulls in all the data
from the mainframe tables.  I am then creating a compare query using the two
previously created queries to make sure that what is entered into both the
Access tables and the Mainframe tables are correct.  

I have approximately 30 fields to compare, of which 95% of them I can run an
IIF statement similar to this and get what I am looking.  Either the fields
match, or they don't match.

IIF ([table1]![Fruits]=[table2]![Fruits], match, unmatched)

However, for the remaining 5%, I want to see if the fields match, but first,
I have to compare like fields.  In other words, if 1 = Yes, and 2 = No, on
the Access tables, it may show 1, and on the Mainframe tables it may show
Yes.  Logically, I know this is a match, but if I use the IIF statement
above, it shows it as unmatched.  

I want to know if there is a way to somehow use an IIF statement to first
say that 1=Yes and 2=No, and then say something similar to the IIF statement
above so that the query will know that 1 and Yes are a match, as well as 2
and No, while 1 and No and 2 and Yes are not a match.

Hope that makes sense.

thanks in advance