C
Comparing Multiple Fields
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.
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.