T
Thomas
I need to create an IIF statement in a query that will check an item on a
form and if that item is a certian value select only that value but if it is
any other value select all values. I have tried the following:
IIf([Forms]![zfrm_SwitchboardSplitSkill]![cbo_ServiceDesk]="CBO Field","CBO
Field",Is Not Null)
If CBO Field is selected in the pull down menu it will locate ony records
with "CBO Field" in the field but if anything else is selected in the pull
down menu it will not locate any records.
To test I have tried entering in just "CBO Field" in the Criterio for the
filed and it will then only find those records where the records contain "CBO
Field". I also tried entering in Is Not Null for the Criteria and the query
then finds all records (this field is set to not allow null values.) Can
anyone tell me why these individual entree work when entered alone but Is Not
Null will not work when in an IIf statemetn.
form and if that item is a certian value select only that value but if it is
any other value select all values. I have tried the following:
IIf([Forms]![zfrm_SwitchboardSplitSkill]![cbo_ServiceDesk]="CBO Field","CBO
Field",Is Not Null)
If CBO Field is selected in the pull down menu it will locate ony records
with "CBO Field" in the field but if anything else is selected in the pull
down menu it will not locate any records.
To test I have tried entering in just "CBO Field" in the Criterio for the
filed and it will then only find those records where the records contain "CBO
Field". I also tried entering in Is Not Null for the Criteria and the query
then finds all records (this field is set to not allow null values.) Can
anyone tell me why these individual entree work when entered alone but Is Not
Null will not work when in an IIf statemetn.