order of operations problem

[dbh139]

I am making calculations in a query and have this:

Overhead Total Cost: IIf([Contractor Table]![Contractor] In ("Alliance"),([Overhead]+[Overhead Markup])*[Material Quantity],0)

When I take out the paranthesis around

[Overhead]+[Overhead Markup]

it works, however the calculation isn't correct. When I keep it the way it is I get a continual error. Do I need to change the order? I have tried parantheses everywhere, but can't seem to get the calculation to work out correct

 

[Philem]

Hullo. Try this UNTESTED modification to your query:

Overhead Total Cost: Iif([Contractor Table]![Contractor] In ("Alliance"),(([Overhead]+[Overhead Markup])*[Material Quantity]),0)

That should do the trick.

HTH

P

 

[dbh139]

That is the first formula i tried. It still produces #error. I have no idea, because the formula you suggested should work. Do you have any other ideas?