Check if a table field is null

[Eranka]

Hi Everyone



i want to insert a value into table if the column is null else ignore.

For example

Name ID Addresss
Sam 01
Mike 02 NY


i want to insert a value into address column for ID 01 instead if updating. how to do this part?

[Micron]

In the query design grid for the field you want to update, enter Is Null as criteria. As long as the field does not contain empty strings (rather than Null) it should work. As always, I suggest that you test/learn using copies of such tables and then examine them to see if all is OK.