ISBLANK how to use in ACCESS

  • Thread starter Thread starter Adrienne
  • Start date Start date
A

Adrienne

I have a field entitled RFA/PA, I would like to establish
a new field entitled Unsolicited. This field is based on
the result of another field entitled RFA/PA. If the
RFA/PA is blank the new Unsolicated field should populate
the word "Unsolicited", if the RFA/PA has a number, it
should populate the new field with the word "Solicited".
In excel I used this function:

=IF(ISBLANK(AB2)=TRUE,"Unsolicited","Solicited")

I'm not sure how to perform this function in Access.
Is there a solution?

Thanks!
 
You should not be storing the Unsolicited column on a table
as it can be derived from the RFA/PA column.

To derive it in a form or report, you can use an unbound
text box and set its controlSource to

=IIf(IsNull([RFA/PA]),"Unsolicited","Solicited")

Hope This Helps
Gerald Stanley MCSD
 
=IF(ISBLANK(AB2)=TRUE,"Unsolicited","Solicited")

I'm not sure how to perform this function in Access.
Is there a solution?
Click to expand...

Try:

IIF(IsNull([AB2], "Unsolicited", "Solicited")
 
Back
Top