G Guest Aug 4, 2005 #1 I would like to have a query check field 1 agents field 2 and if they do not match show the record.
R Rick B Aug 4, 2005 #2 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.
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.
G Guest Aug 4, 2005 #3 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. Click to expand... Click to expand...
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. Click to expand... Click to expand...
S Steve Schapel Aug 4, 2005 #4 KAnoe, In the Criteria of the field 1 column in your query, put the equivalent of... <>[field 2]
