Recent content by 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...

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