I am trying to import a table from another database and then update a table in the current database. To do this I am using the transfer database function in a macro into a new table. I am then using an update query to update the records from the imported table to the local table. The problem is, when there is a field in the imported table that contains a null value, I don't want to update that field. It is not feasible to make all fields have a required entry, by setting the field properties. I tried to use a iif statement but all I can do is input a space if it is null and that erases the current data in that field. This is what I want to avoid. Sorry this is so long winded. Thanks in advance for any help.