K
KLock
I have several update queries to identify different scenerios and update a
comment in the same field. However some of these scenerios can fit for the
same record. Is there a way to keep what the field updated in the first
query with what it would update in the second qeury.
Example
Query 1 - Update FieldC to "FieldA Null" if FieldA is null
Query 2 - UPdate FieldC to "FieldB Null" if FieldB is null
However if both FieldA and FieldB is Null I want FieldC to keep "FieldA
Null" and add "FieldB Null". Instead of replacing the "FiledA Null" with the
update "FieldB Null"
I have more then two queries so just creating a third query to overwrite the
field would not be efficient.
comment in the same field. However some of these scenerios can fit for the
same record. Is there a way to keep what the field updated in the first
query with what it would update in the second qeury.
Example
Query 1 - Update FieldC to "FieldA Null" if FieldA is null
Query 2 - UPdate FieldC to "FieldB Null" if FieldB is null
However if both FieldA and FieldB is Null I want FieldC to keep "FieldA
Null" and add "FieldB Null". Instead of replacing the "FiledA Null" with the
update "FieldB Null"
I have more then two queries so just creating a third query to overwrite the
field would not be efficient.