C
C. Sharp
I have a field called "Contact" in my master table that
may or may not contain data
I need to create a QUERY with the Contact field in it.
Here's the catch: IF 'contact' contains data then I need
to have that data displayed ** BUT ** IF 'contact' is
NULL then it needs to display "NA".
How do I do this in a Query?
may or may not contain data
I need to create a QUERY with the Contact field in it.
Here's the catch: IF 'contact' contains data then I need
to have that data displayed ** BUT ** IF 'contact' is
NULL then it needs to display "NA".
How do I do this in a Query?