I would like to create a query where the value of one of the fields will be based on the presence or absence of values in four other fields. In essence, if field A is null, then STATUS will have one value. If A is not null but B is null, STATUS will have a second value. If A and B are not null but C is, a third value. And, if D is checked, that overrides everything for the foruth value of STATUS.
Question: is this sort of thing possible in a Select query? If so, can someone point me to a reference?
Thanks, and I can provide more information if needed.
Rob