<div>
<br />
How about this:<br />
<br />
=sum(IIf([ps1_bkfst_food] &lt;&gt;&nbsp;0, ([ps1_bkfst_food] - [ps13_bkfst_food]) / [ps1_bkfst_food]), 0)<br />
<br />
mx
</div>



How about this:

=sum(IIf([ps1_bkfst_food] <> 0, ([ps1_bkfst_food] - [ps13_bkfst_food]) / [ps1_bkfst_food]), 0)

mx

<div>
select sum(iif([ps1_bkfst_food] &lt;&gt;&nbsp;0,([ps1_bkfst_food]-[ps13_<wbr />bkfst_food<wbr />])/[ps1_bk<wbr />fs_food],0<wbr />))<br />
<br />
try this
</div>


select sum(iif([ps1_bkfst_food] <> 0,([ps1_bkfst_food]-[ps13_bkfst_food])/[ps1_bkfs_food],0))

try this

<div>
You had a extra paren on the end ... if that's what you mean by blowing up?<br />
<br />
mx
</div>


You had a extra paren on the end ... if that's what you mean by blowing up?

mx

<div>
And maybe this:<br />
<br />
=IIf([ps1_bkfst_food] = 0, , 0, sum(([ps1_bkfst_food] - [ps13_bkfst_food]) / [ps1_bkfst_food]))
</div>


And maybe this:

=IIf([ps1_bkfst_food] = 0, , 0, sum(([ps1_bkfst_food] - [ps13_bkfst_food]) / [ps1_bkfst_food]))

<div>
Thanks everyone. This is the solution that actually worked. &nbsp;I got errors all the other solutions but appreciate the support and effort.
</div>


Thanks everyone. This is the solution that actually worked.  I got errors all the other solutions but appreciate the support and effort.

<div>
What error do you get with the solution I posted @ <a href="http:#a37298940" rel="ugc">http:#a37298940</a>&nbsp; ?<br />
<br />
mx
</div>


What error do you get with the solution I posted @ http:#a37298940 [http:#a37298940]  ?

mx

<div>
<div class="content wysiwyg-content">
Hello, I am trying to get my syntax right in this report textbox equation. &nbsp;Can someone help get the commas and/or paranthesis right. &nbsp;My goal is to make sure that I'm not trying to subtract or divide with zero. &nbsp;Thanks.<br />
<br />
Current Script Blowing Up:<br />
<br />
=sum(iif([ps1_bkfst_food] &lt;&gt;&nbsp;0,([ps1_bkfst_food]-[ps13_<wbr />bkfst_food<wbr />])/[ps1_bk<wbr />fst_food])<wbr />,0))
</div>
</div>


Hello, I am trying to get my syntax right in this report textbox equation.  Can someone help get the commas and/or paranthesis right.  My goal is to make sure that I'm not trying to subtract or divide with zero.  Thanks.

Current Script Blowing Up:

=sum(iif([ps1_bkfst_food] <> 0,([ps1_bkfst_food]-[ps13_bkfst_food])/[ps1_bkfst_food]),0))

IF  Statement

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.