Sum if no value?

hELLO,

I have a text box in my report that have the the below formula that
sum the quantity of shipments not on time. Up to here, everything is
good, but now i try to figure how can I sum
if there is no value?
=Sum([SumOfDifférence de Journée])

Please help!!!

Thank you!
Fred's

re: Sum if no value?

By Jet's reckoning, null + null + null doesn't add up to any number. If you
want to show 0 in your report when there aren't any shipments not on time,
use the NZ function. Like this:

sum(nz([SumOfDifférence de Journée], 0))

Chris
Microsoft MVP


Fred's wrote:--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200806/1

re: Sum if no value?

On Jun 30, 4:15*pm, "Chris O'C via AccessMonster.com" <u29189@uwe>
wrote:Hello,

I need to sum the total of shipment not in time when there is no data.

re: Sum if no value?

Maybe I don't understand your question. What does your report show when you
use your original expression, =Sum([SumOfDifférence de Journée]) when there's
no data and what does it show when you use the NZ function in your expression,
=sum(nz([SumOfDifférence de Journée], 0)) when there's no data? My thinking
is that it should show 0 as the sum when there's no data. Is that not what
you want?

Chris
Microsoft MVP


Fred's wrote:--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200807/1

re: Sum if no value?

On Thu, 3 Jul 2008 10:05:59 -0700 (PDT), "Fred's"
<frederic10_mess@hotmail.comwrote:
Perhaps there is a small difficulty here with translation. Do you mean
that you need a Count of records for which [SumOfDifference de
Journee] is null?