Adding fields in same update query with two if statements

[tagteam]

I have an if statement to update two field values:

IIf([MaterialSign]="D",CCur([LaborCharge]/100),CCur([LaborCharge]/100)*-1)
IIf([MaterialSign]="D",CCur([MaterialCharge]/100),CCur([MaterialCharge]/100)*-1)

Also in the update query I have

NetCharge
Update to
[LaborChargeNet]+[MaterialChargeNet]

The if statments work fine, however the Net charge does not update. Is this because at the time of the query the value is not updated yet? Can I do this all in one query or will it take two queries?

[John_G]

Are those two Iif expressions in the "Update To" line of the query, and if they are, what fields are they updating? If they are not in the "Update To", how are you using them?

Where are the values for [LaborChargeNet] and [MaterialChargeNet] coming from?

[tagteam]

All three are in the update to section of the query
I am afraid that the third one may not be able to calculate because it is dependent on the first two.
I need the updated Labor and the Update Material to be able to get the Updated Net Charge. So I am wondering if there is some way to make it update Labor AND Material and then once those are done do the Net Charge update.

[John_G]

Instead of referring to the first two calculated fields by their alias ([LaborChargeNet] and [MaterialChargeNet]), just use the original expressions again, so net charge will update to:

IIf([MaterialSign]="D",CCur([LaborCharge]/100),CCur([LaborCharge]/100)*-1) + IIf([MaterialSign]="D",CCur([MaterialCharge]/100),CCur([MaterialCharge]/100)*-1)

[tagteam]

I see, that is clever. I should have thought of that. Since it is not updating then then it will still use the earlier values. I have tested it and it works. Thanks, that saves me an extra query in my subroutine.