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

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

Post by bGF0aG » Wed, 04 Jul 2007 02:20:01


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.
 
 
 

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

Post by Jeff Boyc » Wed, 04 Jul 2007 02:36:27

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

 
 
 

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

Post by S0FSTCBERV » Wed, 04 Jul 2007 02:44:01

Try this ---
IIf([DisenrolledDate] Is Null And [enrolledDate] Is
Null,"Active",[DisenrolledDate])
--
KARL DEWEY
Build a little - Test a little
 
 
 

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

Post by S0FSTCBERV » Wed, 04 Jul 2007 02:44:01

Try this ---
IIf([DisenrolledDate] Is Null And [enrolledDate] Is
Null,"Active",[DisenrolledDate])
--
KARL DEWEY
Build a little - Test a little