K
KAnoe
I would like to have a query check field 1 agents field 2 and if they do not
match show the record.
match show the record.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Rick B
Then just build a wuery with all your fields. Under 'field1' just put the
criteria...
not [field2]
This will only pull fields where the two do not match.
criteria...
not [field2]
This will only pull fields where the two do not match.
K
KAnoe
Thanks Rick
Rick B said:Then just build a wuery with all your fields. Under 'field1' just put the
criteria...
not [field2]
This will only pull fields where the two do not match.
--
Rick B
KAnoe said:I would like to have a query check field 1 agents field 2 and if they do not
match show the record.
S
Steve Schapel
KAnoe,
In the Criteria of the field 1 column in your query, put the equivalent
of...
<>[field 2]
In the Criteria of the field 1 column in your query, put the equivalent
of...
<>[field 2]