Not like

[Guest]

I would like to have a query check field 1 agents field 2 and if they do not
match show the record.

 

[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.

 

[Guest]

Thanks Rick

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

I would like to have a query check field 1 agents field 2 and if they do not
match show the record.

 

[Steve Schapel]

KAnoe,

In the Criteria of the field 1 column in your query, put the equivalent
of...
<>[field 2]