Maybe I don't understand your question. What does your re****t 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:
>On Jun 30, 4:15 pm, "Chris O'C via AccessMonster.com" <u29189@[EMAIL PROTECTED]
>
>wrote:
>> 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,
>[quoted text clipped - 20 lines]
>> --
>
>Hello,
>
>I need to sum the total of ****pment not in time when there is no data.
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200807/1
|
