by "Chris O'C via AccessMonster.com" <u29189@[EMAIL PROTECTED]
>
Jun 30, 2008 at 08:15 PM
By Jet's reckoning, null + null + null doesn't add up to any number. If
you
want to show 0 in your re****t when there aren't any ****pments not on time,
use the NZ function. Like this:
sum(nz([SumOfDifférence de Journée], 0))
Chris
Microsoft MVP
Fred's wrote:
>hELLO,
>
>I have a text box in my re****t that have the the below formula that
>sum the quantity of ****pments 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
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200806/1
