R rbrule Registered User. Local time Today, 15:31 Joined Jan 13, 2004 Messages 108 May 6, 2004 #1 Hello, Is it possible to compare two fields in a query, and pick out only those that don't match? If so how would I go about doing it?
Hello, Is it possible to compare two fields in a query, and pick out only those that don't match? If so how would I go about doing it?
J Jon K Registered User. Local time Today, 20:31 Joined May 22, 2002 Messages 2,209 May 6, 2004 #2 In the Criteria for [Field1] put:- <>[Field2]
R rbrule Registered User. Local time Today, 15:31 Joined Jan 13, 2004 Messages 108 May 6, 2004 #3 Jon K said: In the Criteria for [Field1] put:- <>[Field2] Click to expand... Thank you Jon, I appreciate your help.
Jon K said: In the Criteria for [Field1] put:- <>[Field2] Click to expand... Thank you Jon, I appreciate your help.
