unmatched query without blanks

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have used the unmatched query wizard to compare fields of 2 tables but the result is giving me the fields that are different as well as fields that are empty for both tables. Is there a way of only getting the results of the differences and not the blank fields?

Thanx
 
Add criteria under the field you don't want to see any blanks and add the
phrase: Is Not Null in the criteria section of the query.

jjebb said:
Hi,

I have used the unmatched query wizard to compare fields of 2 tables but
Click to expand...
the result is giving me the fields that are different as well as fields that
are empty for both tables. Is there a way of only getting the results of
the differences and not the blank fields?
 
Back
Top