Can I update multiple columns based on different criteria in one update query? How to set it up in QBE?
Name Height Weight Basketball Football Bob 75 149 Yes No
Set Basketball to Yes if height is over 70 and No otherwise
Set Football to Yes if weight over 200 and No otherwise.
Thank you!