| | |
|
|
|
=sum() |
|---|
| message from =?Utf-8?B?Sk1vcnJlbGw=?= on 11 May 2004 |
=([fsum]+[wsum]+[osum])
when fsum > 0 AND wsum > AND osum > 0 the =sum() returns a value.
If fsum OR wsum OR osum = 0, =sum() returns nothing.
To me, that doesn't make sense. How can I get the =sum() to give me a value of the 3 values, regardless of their value.
tia,
JMorrell
|
| John Vinson replied to =?Utf-8?B?Sk1vcnJlbGw=?= on 11 May 2004 |
I strongly suspect that the Sum() is returning nothing when one of the
values is NULL, not zero. Do the fields in fact contain a numeric
zero, or are they blank (NULL)?
Try
=(NZ([fsum]) + NZ([wsum]) + NZ([osum]))
John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public
|
| =?Utf-8?B?Sk1vcnJlbGw=?= replied to John Vinson on 12 May 2004 |
That did it. I took the Sum() portion away and it works now. Thanks again for all your help.
|
| M Skabialka replied to =?Utf-8?B?Sk1vcnJlbGw=?= on 11 May 2004 |
=sum(nz([fsum])+nz([wsum])+nz([osum]))
Mich
"JMorrell" <anonymous@discussions.microsoft.com> wrote in message
news:D4E121DA-5C4E-4A2B-B467-BFAAC8CBB8CA@microsoft.com...
value of the 3 values, regardless of their value.
|
| =?Utf-8?B?Sk1vcnJlbGw=?= replied to M Skabialka on 11 May 2004 |
The =sum(nz([fsum])+nz([wsum])+nz([osum])) doesn't work. I gives the error,
"The Microsoft Jet database engine does not recognize '[fsum]' as a valid field name or expression."
|
| Michael replied to =?Utf-8?B?Sk1vcnJlbGw=?= on 11 May 2004 |
Perhaps try just =(Nz([fsum])+Nz([wsum])+Nz([osum]))
|
|
Archived message: =sum() (Microsoft Access Error Message)
