twist on addition

[ppoole16]

I'm using the expresstion =[Money1]+[Money2] to sum two fields. However, I also need the expresstion to over rule the addition and make the total display 0 if a checkbox named "no bond" is checked. Any help would be great. Thanks.

 

[WayneRyan]

ppoole,

Me.YourField =Iif([no bond] = True, [Money1] + [Money2], 0)

Wayne

 

[Fizzio]

=iif(NameofCheckbox = True,0 ,[Money1] + [Money2])

but this will depend on where you are performing the calculation, on a form or in a query.

Wayne got there First with the VBA example (except he got the statements all mixed up - but he did remember the name of the Checkbox!)

 

[ppoole16]

Thanks

You guys are great!

 

[WayneRyan]

Fizzio,

Is having the function's arguments in the opposite order really
all that bad?

Wayne

 

[Fizzio]

Terrible, Should be a crime punishable only by hanging (mind you so should not lokking at what the control is called also)