Unmatching Query

[pablofonto]

Hi,

I need help creating an unmatching query. I've used the wizard before to create an unmatching query to compare two tables and it was working okay until I got a record with a blank value (null). The wizard creates the unmatching query by indicating to pull a value where doesn't exist in one of the tables by entering in the criteria "is Null". The problem with this is that when there is a blank any where in a row it pull up that record. I currently have a table "table 1" with data and a "table 2" with updated data from the table 1. I want the system to tell me if there are any changes in the table 2 from table 1, but I don't want records with blank fields. Does anyone know how can I do this?, please help!

thanks,

pablo

 

[neileg]

You would use the 'Is Null' criterion in the primary key field to find the unmatched records. You could add a further criterion in the field that is potentially null 'Is Not Null'.

A thought, however. Why do you have records in a table that contain no data? Surely they must contain some data, otherwise your design is wrong. Are you deleting data when you should be deleting records?

 

[pablofonto]

Thank you Neil! TABLE 2 is information coming from a different system that has blank fields and TABLE 1 is where I manually fill some of those blank fields. The query I need is to match the two tables and see if any of my existing information in TABLE 1 has been updated in TABLE 2 (info from the other system), but I don't want my query to show the records with blank fields since some of that information has been already update in TABLE 1. Any other ideas?