Criteria for an IIF Statement.

[huttojb]

Hi Gent’s

This is my first posting here,

I’m looking to put a criteria on an IIF statement,

Hol_Period: IIf([CAN_Date]="False" Or [CAN_XM]="False" Or [CAN_paper]="False","True","False")

This will output either True or False, True if any of the other 3 fields contain a False and False if all contain a True.

How can I put a criteria on this to show me only True’s, without using another query???

Thank you

Jason

 

[ejstefl]

I assume you are using the Query builder. Just put "True" in under the criteria for that column.

 

[huttojb]

Doesn't work cos it's an IIF Statement. I worked it out so i'll post it just incase anyone else needs it for a templete.

Hol_Period: IIf((IIf((Now()) Between [Can_From_Date] And [Can_to_Date],"True","False"))="False" Or (IIf([XM_Freq]=[Freq_XM],"True","False"))="False" Or (IIf([Can_Paper_Description]=[Paper_Desription],"True","False"))="False","True","False")

jason

 

[ejstefl]

I'm glad you found a solution - however, you certainly CAN use criteria for IIF statements. Did you add the quotes around the "True" criteria statement?