unmatched query without blanks

J

jjebb

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
 
G

GVaught

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Finding the proper style field and the numbered paragraph value within the style 0
How to display zero value in blank fields of Cross Tab query 0
Incone & Expenses Statement 0
Finding the right style field in VBA 0
Dealing with a Pivot Table (when I don't want to) 0
Adding data to MS Access from csv file 0
Compare 2 tables 1

Top