Formating return value in IIF statement not working

[Jerry Maiapu]

The following is giving error in query:

Credit: IIf([Overtime]="AOT" Or [ClockIn]="Weekend" Or [ClockIn]="Holiday","0.00",
 Format([HrtMints]-8.35),"Fixed"))
 

It was fine but gives error when I tried to format the False portion of the IIF statement. Want to return a fixed value.

 Format([HrtMints]-8.35),"Fixed"

Even this does not work:

Credit: Format(IIf([Overtime]="AOT" Or
[ClockIn]="Weekend" Or [ClockIn]="Holiday","0.00",[HrtMints]-8.35),"Fixed")

Help appreciated

[NeoPa]

You have a closing parenthesis ")" after your 8.35 Jerry ;)

[Jerry Maiapu]

Sometimes we are so busy that we find quite hard to spot such small mistakes.
Thanks a lot Neo.


This worked though

Credit: Format(IIf([Overtime]="AOT" Or
    [ClockIn]="Weekend" Or [ClockIn]="Holiday","0.00",[HrtMints]-8.35),"Fixed")
 

[NeoPa]

Absolutely Jerry :)

I should point out though, even though it may not be important to you now, that what you posted may look as if it's worked, but technically doesn't. It will give you what you're after sure enough, but when it resolves to True the format of fixed is not effective. For that to work as I imagine you intended, you would need either :

Credit: IIf([Overtime]='AOT' Or
            [ClockIn]='Weekend' Or
            [ClockIn]='Holiday','0.00',Format([HrtMints]-8.35,'Fixed'))

or :

Credit: Format(IIf([Overtime]='AOT' Or
                   [ClockIn]='Weekend' Or
                   [ClockIn]='Holiday',0,[HrtMints]-8.35),'Fixed')

This is being pretty picky though. I just wanted to bring the point to your attention in case you weren't aware.

[Jerry Maiapu]

Thanks for that Neo.

I will use either of them