Squidinker
Registered User.
- Local time
- Today, 20:31
- Joined
- Jun 28, 2007
- Messages
- 11
Hi,
Should be a very quick question for someone with more experience than me (i.e. everyone on here):
What is the correct syntax in an IIf function that allows "Is Null" to be the criteria if the logic is met?
I have an IIf statement as a field's criteria in a query and one of the results of the IIf requires only those records that have a Null in that field.
I have tried:
IIf(([Forms]![Available Players]![FilterOwned])=0,"","Is Null") ..."Expression typed incorrectly"
IIf(([Forms]![Available Players]![FilterOwned])=0,"",Is Null) ...runs without error but does not filter, indeed it shows no records at all.
When I go back into the query design the criteria has changed to:
IIf(([Forms]![Available Players]![FilterOwned])=0,"",([Players Auction].[Owner]) Is Null)
Please help!
Should be a very quick question for someone with more experience than me (i.e. everyone on here):
What is the correct syntax in an IIf function that allows "Is Null" to be the criteria if the logic is met?
I have an IIf statement as a field's criteria in a query and one of the results of the IIf requires only those records that have a Null in that field.
I have tried:
IIf(([Forms]![Available Players]![FilterOwned])=0,"","Is Null") ..."Expression typed incorrectly"
IIf(([Forms]![Available Players]![FilterOwned])=0,"",Is Null) ...runs without error but does not filter, indeed it shows no records at all.
When I go back into the query design the criteria has changed to:
IIf(([Forms]![Available Players]![FilterOwned])=0,"",([Players Auction].[Owner]) Is Null)
Please help!