G
Guest
We have a database for tracking clients through a series of classes. There
may be 4, 5, or 6 classes in a unit. We want to do a report that shows the
LAST class date in the unit. I suppose I should use a nested IIF statement,
but I'm not sure how to do it. I want to say that if Class 6 date is null,
print the date of Class 5, but if Class 5 date is also null, print the date
of Class 4. I get as far as:
=IIF([Clas6] Is null, [Class5], IIf([Class5] Is null, [Class4],???))
I'm not sure what to put in for the ??? Is there a better way to show the
LAST date that is not null? Thanks in advance!
may be 4, 5, or 6 classes in a unit. We want to do a report that shows the
LAST class date in the unit. I suppose I should use a nested IIF statement,
but I'm not sure how to do it. I want to say that if Class 6 date is null,
print the date of Class 5, but if Class 5 date is also null, print the date
of Class 4. I get as far as:
=IIF([Clas6] Is null, [Class5], IIf([Class5] Is null, [Class4],???))
I'm not sure what to put in for the ??? Is there a better way to show the
LAST date that is not null? Thanks in advance!