Iff Statement Question

[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!

 

[Ken Snell \(MVP\)]

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?

 

[Joshua McLemore]

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

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>

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!

 

[John W. Vinson]

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."

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.