iif then question...

[Kim W. via AccessMonster.com]

You've helped me before... so let's try again....(I did not create this
particular db): This database is an Employee Leave Balances database.

Basically, I have a field [LeaveType] that returns two possible results, FH
or VAC. In some cases, an employee may have both Leave Types. Each result
returns a new record.

For example:
901- Jane Doe, FH, 8
901- Jane Doe, VAC, 16

I've sorted by lastname, and have grouped on ID#. The report looks fine;
however, I want to add a NOTE: to the bottom of the page that reads:

=IIf([leavetype]="FH","NOTE: Our records indicate that you have not taken
your Floating Holiday(s) yet. As a reminder, if you do not take your
Floating Holiday(s) by June 30, 2009, you will lose it/them. Floating
Holiday hours do not roll-over to the next Fiscal Year.",IIf([leavetype]
="VAC","NOTE: Our records indicate that you are close to or are capping out
on your Vacation Leave. As a reminder, Classified Employees can only accrue
240 hours of Vacation. If your total leave goes over 240 hours, you stop
accruing those hours and essentially lose them."))

QUESTION
If however, a person has both types of leave, can I combine the statements
and how would I do that? I've tried, just not successfully!

As always, thanks for your help!

Kim

 

[KARL DEWEY]

Try this ---
=IIf([leavetype]="FH","NOTE: Our records indicate that you have not taken
your Floating Holiday(s) yet. As a reminder, if you do not take your
Floating Holiday(s) by June 30, 2009, you will lose it/them. Floating
Holiday hours do not roll-over to the next Fiscal Year.","") OR
IIf([leavetype]="VAC","NOTE: Our records indicate that you are close to or
are capping out on your Vacation Leave. As a reminder, Classified Employees
can only accrue 240 hours of Vacation. If your total leave goes over 240
hours, you stop accruing those hours and essentially lose them.","")