In Table A, I want to update this table so that if Column B is empty, I will replace the value for that row with the value in Column A. If Columnb B is not empty, then the value in Column B will remain.
Row 1 Column A = "Dog" Colmn B = " " (empty cell)
then this is updated to:
Row 1 Column A = "Dog" Column B = "Dog"
Row 2 column A = "Dog" Column B = "Cat"
then this row will remain as it is since B was initially filled.
I prefer a non-SQL solution (i.w. how would I arrange this in the Query Design window using criterias and expressions.