how do i use an if is null, and if is not null statement together

[latha]

I have to compare two columns of data, and show the status in column three.
Column1 = enrolleddate, Column 2= DisenrolledDate, Column 3 = Status
If column1 and column2 are null, "Active",
if column2 is not null, then disenrolleddate
Thanks for helping me.

 

[Jeff Boyce]

If you were using a spreadsheet, you might need that third column.

In Access you can simply use a query to do the comparison and generate the
"calculated" value.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[KARL DEWEY]

Try this ---
IIf([DisenrolledDate] Is Null And [enrolledDate] Is
Null,"Active",[DisenrolledDate])