I have created an update query to auto populate the value of one field based on the value of another field.
I have two fields "Level" and "Document"
if Document is A, Level needs to be 1
if Document is B, Level needs to be 2
if Document is C, Level needs to be 3
as far as I can see the GUI only lets you enter one criteria, but I am sure there is a way to avoid three different update queries and do it all in one, any suggestions?