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?
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?
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.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.