Empty field

[bigbadbess24]

I am trying to make a query with two tables. Each row consist of a student ID, their name and all their personal information. Both tables are exactly the same. But one table is a link table. That link table gets update every so often from an outside program and the other table is not linked. I want to be able to run a query that updates certain fields called "address changes". I have figured out how to find the updates, but I am having a problem with a field that is blank. If I have a field in the non-linked table that is empty but there is information in the linked table, it does not see it. Is there a way to get around this empty field problem?

Thank

 

[KenHigg]

I think I would attack this with DAO/ADO using recordsets... Sorry not to be able to elaborate but it's quiting time here at work...

 

[AlienRay]

To find records where the static table differs from the linked table, you would set the field criteria to something like: <>[linkedtable].[addressfield].

If you also want to find records where new information exists, just change the field criteria to : Is Null or <>[linkedtable].[addressfield].

 

[Banana]

Would unmatched query (with a wizard) work in this case?