Hi all,
I want to use an Iff statement in a query
If "Dummy" = false, then I only want to see all the record with dummy as false else, if there are no dummy = false in the records set, just show me dummy = True
Basically I first want to filter dummy = false (10 records), if no, the I want to see the dummy = true (1 record)
My Iff statement does not give me the required result.
I want to use an Iff statement in a query
If "Dummy" = false, then I only want to see all the record with dummy as false else, if there are no dummy = false in the records set, just show me dummy = True
Basically I first want to filter dummy = false (10 records), if no, the I want to see the dummy = true (1 record)
My Iff statement does not give me the required result.
IIf([Material Data File]![Dummy]="0","0","-1")