Iff Statement Question

  • Thread starter Thread starter Joshua McLemore
  • Start date Start date
J

Joshua McLemore

Hello,

I'm trying to use the following 'Iff' statement and it's not working out for
me.

Iff(([tblCrew_Event_Matching]![Event]=Yes),([tblCrew_Event_Matching].[Event/Room])=[Forms]![frm
All Events]![Event Name],([tblCrew_Event_Matching].[Event/Room])=[Forms]![frm
All Events]![Part 1 Location])

I'm using this in a query and need it to make the query criteria equal one
or the other values being pulled from a form.

Thanks for any help!
 
First, the function is IIf, not Iff.

Second, what type of field / format is the Event field in the
tblCrew_Event_Matching table? Is it a text field? A boolean field? something
else?

Third, in what context are you trying to use this expression? On a form? As
a table-level validation in ACCESS 2007? Somewhere else?
 
Hi Ken,

The "IFF" to "IIF" change made a really nice difference!! I don't have it
working quite right yet, but I'm now on the way. Thank you so much!

Just FYI ... it's a text field and I'm using it as the control in a combo
field sql statement to pick "this" but if that is null, pick "that."

Thanks again!
--
Joshua


Ken Snell (MVP) said:
First, the function is IIf, not Iff.

Second, what type of field / format is the Event field in the
tblCrew_Event_Matching table? Is it a text field? A boolean field? something
else?

Third, in what context are you trying to use this expression? On a form? As
a table-level validation in ACCESS 2007? Somewhere else?
--

Ken Snell
<MS ACCESS MVP>




Joshua McLemore said:
Hello,

I'm trying to use the following 'Iff' statement and it's not working out
for
me.

Iff(([tblCrew_Event_Matching]![Event]=Yes),([tblCrew_Event_Matching].[Event/Room])=[Forms]![frm
All Events]![Event
Name],([tblCrew_Event_Matching].[Event/Room])=[Forms]![frm
All Events]![Part 1 Location])

I'm using this in a query and need it to make the query criteria equal one
or the other values being pulled from a form.

Thanks for any help!
Click to expand...
Click to expand...
 
Just FYI ... it's a text field and I'm using it as the control in a combo
field sql statement to pick "this" but if that is null, pick "that."
Click to expand...

You don't even need IIF for that purpose: the NZ function converts NULL to any
chosen value.

=NZ([This], [That])

will return the value in This if there is a non-null value, and if This is
null it will return That.
 
Back
Top