I am using Access to access a SQL table. What I am trying to do is that I have a date field called DateCleared. I have another field called Cleared. What I want to do is that if DateCleared is empty then Cleared is No and if DateCleared has a date in it then Cleared is Yes.
I am familiar with Access but new to SQL.
Thanks
Tom
I am familiar with Access but new to SQL.
Thanks
Tom