Access 2000

[draegun]

I have a query updating a table from another table.  Sometimes the fields updating are populated with info, while other times they are blank.  I want to keep the populated info even when the updating info is blank.

How do I do this???  Thanks for any and all help.

[Biyobi]

You should be able to add an IF statement saying to only update a field if the "new" information is NOT null (i.e., it has new data).  I haven't played with Access in a year or so but something to that effect should be possible.

[draegun]

Beautiful.  Had someone help with the IIF script? and it worked like a charm.

thanks.