Iif Statement - Operand Error

[captainmorgan]

I have attempted to use the following IIF statement in a query, with no success.

Iif([Branch]="580" OR "585", Iif(Month([Estimate_Completed])=Month(Now()), [Charge]=[Charge]+40), Iif(Month([Estimate_Completed])=Month(Now()), [Charge]=[Charge]+100) Iif(Month([Layout_Completed])=Month(Now()),[Charge]=[Charge]+100))

I tried to include a field in my query name Charge using the,

Charge:Iif(...code above...)

Method, but I get the following error;

You have entered an operator, such as the + operator, in an expression without a corresponding operand.

What the hell does this mean? Help?

[missinglinq]

Trying to follow your code has given me a worse headache than if I had drunk an entire bottle of Catain Morgan, but the first (and maybe only) mistake is:

[Branch]="580" OR "585"

This needs to be

[Branch]="580" OR [Branch] ="585"

Linq ;0)>

[JKing]

You need to set something = "585" in your OR clause...

Try this

Iif([Branch]="580" OR [Branch] = "585", Iif(Month([Estimate_Completed])=Month(Now()), [Charge]=[Charge]+40), Iif(Month([Estimate_Completed])=Month(Now()), [Charge]=[Charge]+100) Iif(Month([Layout_Completed])=Month(Now()),[Charge]=[Charge]+100))
 

On a side note there maybe a missing comma or bracket in there but lets try one thing at a time.

[mlcampeau]

I have attempted to use the following IIF statement in a query, with no success.

Iif([Branch]="580" OR "585", Iif(Month([Estimate_Completed])=Month(Now()), [Charge]=[Charge]+40), Iif(Month([Estimate_Completed])=Month(Now()), [Charge]=[Charge]+100) Iif(Month([Layout_Completed])=Month(Now()),[Charge]=[Charge]+100))

I tried to include a field in my query name Charge using the,

Charge:Iif(...code above...)

Method, but I get the following error;

You have entered an operator, such as the + operator, in an expression without a corresponding operand.

What the hell does this mean? Help?

I've never seen anyone close the IIF bracket before starting the next iif, so that could be causing the error. I fixed the brackets and added commas, and added the "" for if the statement is false. Try this:

Iif([Branch]="580" OR [Branch] = "585", Iif(Month([Estimate_Completed])=Month(Now()), [Charge]=([Charge]+40), Iif(Month([Estimate_Completed])=Month(Now()), [Charge]=([Charge]+100), Iif(Month([Layout_Completed])=Month(Now()),[Charge]=[Charge]+100, ""))))
 

[JKing]

Trying to follow your code has given me a worse headache than if I had drunk an entire bottle of Catain Morgan, but the first (and maybe only) mistake is:

[Branch]="580" OR "585"

This needs to be

[Branch]="580" OR [Branch] ="585"

Linq ;0)>

Must have been responding at the same time there Linq didn't mean to step on your toes though it seems we both came to the same conclusion.

[missinglinq]

Ouch! LOL! I try to check before posting, but the way this forum is set up makes it a real pain! If you get distracted at all in mid-reply, to check before posting you've got to copy your response, back out and reload the page, and if no one else has replied, click on "Post a reply" and paste your response in and post it! Life's way too short!

Linq ;0)>

The guys that really frost me, and we don't see much of it here, knock wood, are the ones who come along hours later and post a solution/answer that's already been posted!

[mlcampeau]

The guys that really frost me, and we don't see much of it here, knock wood, are the ones who come along hours later and post a solution/answer that's already been posted!

sorry, i was just fixing the brackets and commas that no one addressed