Search results

I have a query with 3 fields. If all 3 fields have the same text value, I want the output value to say "complete", if not "open" Is there a function to do this? I've looked at IIF and SWITCH🤯 Your help is greatly appreciated.

Hello All... I am new to MS Access. I'm trying to make my daily job tasks more efficient. Unfortunately, I do not have VBA experience. I look forward to learning from this community. Thank you