Query ifff statement with calculation?

[MushroomKing]

Hi everyone!

I have a small question that im unable to find the exact solution for.
It's driving me craaaaazy

I have a query where I want to apply this:

actualtime: IIf([daytext]="vrijdag" Or "Friday",([timediff]-48))


Now obviously its not working...but why?

If my daytext is equal to vrijdag or Friday, I want to subtract 48 from my timediff value.


Could someone help me out with this small but annoying expression?
Thanks in advance!!!

 

[Gasman]

You need True and False arguments I would have thought?

However try

IIf([daytext]="vrijdag" Or [daytext] = "Friday",([timediff]-48))

 

[MushroomKing]

Hi Gasman! Always good to see you in the thread

Still doesn't work for some reason. I get an #error in my field.



(sorry, will quote with code tag next time, its corrected)

 

[isladogs]

As Gasman said you also need a 'false' argument. For example

IIf([daytext]="vrijdag" Or [daytext] = "Friday",[timediff]-48, 1234)

Replace 1234 with whatever you want when daytext is neither of those values