Can Access compare multiple fields from multiple tables?

[Guest]

I am wondering if a macros can be written to compare multiple fields from one
table to anither. For example:

Tbl_Michigan_Address Tbl_Ohio_Address
Address Street Zip Address Street
Zip
12345 Hill St 55555 12345 Hill St
44444
67890 Lane St 55555 67890 Lane St
55555

Can access compare the Address, Street, and Zip fields separately for line
one of both tables and return a value of FALSE because the Zip numbers are
different. And similarly can it return a value of TRUE for line 2 because
all 3 fields are the same. BUT it but conpare each field separately NOT the
rows.

 

[Brian Tillman]

Comparing Multiple Fields <Comparing Multiple

I am wondering if a macros can be written to compare multiple fields
from one table to anither. For example:

Who knows? Ask in an Access newsgroup.