Help with IIF Statement in a Query

[Woelfe]

Hello! I am hoping to get some help with an expression I am trying to write in an Access query. I have managed to create an expression called Cumulative that adds two other fields together. The new expression I am having trouble writing is to evaluate the amount in Cumulative and return either a True or False answer based on the IIF function.

What I have written is:

IIf ([Cumulative] > «Expr» = «Expr» "3772", [Cumulative] * «Expr» "0.0106065", "40")

Basically, if Cumulative is greater than or equal to 3772 I want it to take Cumulative and multiply it by by 0.010605, otherwise just show 40.

I built this using the Expression Builder, but when I try to run the query I get an error: The expression you entered contains invalid syntax - you may have entered an operand without an operator.

I am very new to building expressions so any suggestions are greatly appreciated.

Thank you in advance...

 

[Norie]

Remove each instance of this from the expression.

<<Expr>>

I would also suggest you remove the quotes from the numbers.

 

[Woelfe]

Remove each instance of this from the expression.

<<Expr>>

I would also suggest you remove the quotes from the numbers.

Norie, thank you so much! The <<Expr>> was dropped in while using the builder automatically. Originally I didn't have the quotes on the numbers, but then thought maybe I should. It worked perfectly now.

 

[Norie]

Woelfe

No problem.

It's sometimes useful for the builder to include that - it can help remind you what arguments are needed.

But it can be annoying sometimes.