Calculating fields using iif and checkbox value

[jree3000]

Hello!

I'm working on a query that I need some expert advise on. I have fields that are set up to calculate value based on other fields. These are working fine. Problem is I want to add a condition that is based on a checkbox field and I'm not sure how to do that. Right now my query field looks like this:

RUP1_TotalParticles: [RUP1_particles]*[RUP1_TotalVol]

It returns the appropriate number based on the value of those fields. Now I also have a checkbox field called "RUP_good". I only want the RUP1_TotalParticles field to calculate if the RUP_good field is checked to yes (true). If it is not checked to yes, I want it to return a value of 0. Hopefully that makes sense.

I'm pretty sure I can do this using the IIf function but I'm a novice and not quite sure how to structure that properly. Thanks in advance for any help.

[June7]

IIf() in plain English:

If condition is true do this else do this.

Try:

RUP1_TotalParticles: IIf([RUP_good], [RUP1_particles]*[RUP1_TotalVol], 0)

[jree3000]

That did it! Thank you, June7!