Recent content by zavexx

Let me start by saying I'm a novice, complete beginner. So I'll explain it my elementary language... The headers are - SL Form - Closing Set - Data Room. When the documents have not been received the user will enter Open, once the document has been received the user will enter complete. The...

Thank you The Doc Man. I am a complete novice, some of my understanding is very limited. The code you provided almost worked, the end result is showing complete even though the data in the fields are not all complete My thinking is, If SL Form is "Complete" and Closing Set is "Complete", but...

My apologies...I am a complete novice. Thank you for your input.

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