Conditional

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, there! I'm trying to figure out how to have one of my fields display a
record conditionally.

If [MemberCategory] is "Add'l Pay" or "Family Pay", I want [MemberCategory]
to show a blank, otherwise list appropriate [MemberCategory].

Everything I've tried yields me #Error.

Thanks in advance!
 
In the control source of the field try

=IIf( [MemberCategory] = "Add'l Pay" or [MemberCategory] = "Family Pay", "",
[MemberCategory])
 
Thanks, Ofer.
Sadly that didn't work either. Any suggestions?

Ofer said:
In the control source of the field try

=IIf( [MemberCategory] = "Add'l Pay" or [MemberCategory] = "Family Pay", "",
[MemberCategory])

--
\\// Live Long and Prosper \\//
BS"D


Stephanie said:
Hi, there! I'm trying to figure out how to have one of my fields display a
record conditionally.

If [MemberCategory] is "Add'l Pay" or "Family Pay", I want [MemberCategory]
to show a blank, otherwise list appropriate [MemberCategory].

Everything I've tried yields me #Error.

Thanks in advance!
Click to expand...
Click to expand...
 
What do you get?
Is the [MemberCategory] is a name of a field in the table?
Does the [MemberCategory] apear in the record source of the report?

--
\\// Live Long and Prosper \\//
BS"D


Stephanie said:
Thanks, Ofer.
Sadly that didn't work either. Any suggestions?

Ofer said:
In the control source of the field try

=IIf( [MemberCategory] = "Add'l Pay" or [MemberCategory] = "Family Pay", "",
[MemberCategory])

--
\\// Live Long and Prosper \\//
BS"D


Stephanie said:
Hi, there! I'm trying to figure out how to have one of my fields display a
record conditionally.

If [MemberCategory] is "Add'l Pay" or "Family Pay", I want [MemberCategory]
to show a blank, otherwise list appropriate [MemberCategory].

Everything I've tried yields me #Error.

Thanks in advance!
Click to expand...
Click to expand...
Click to expand...
 
Back
Top