using sum and Iif statement

[Guest]

I am using unbound text box to sum some information, and if there is nothing
to add I would like the text box to have 0 else the sum of the books. The
following is what I have but am not sure what to put in the ?????
=iif(sum([books])=0, 0, ?????)

 

[Guest]

Try use the NZ, It will display the sum of books, and if there are none it
should display 0

=Sum(NZ([books], 0))

 

[Guest]

It would read =iif(sum([books])=0, 0, sum([books]))

But why this way?

If you want to display zero if the sum is zero and sum if it is not zero why
not just sum([books])

 

[Guest]

sum(nz([books])) will work

sam

It would read =iif(sum([books])=0, 0, sum([books]))

But why this way?

If you want to display zero if the sum is zero and sum if it is not zero why
not just sum([books])

I am using unbound text box to sum some information, and if there is nothing
to add I would like the text box to have 0 else the sum of the books. The
following is what I have but am not sure what to put in the ?????
=iif(sum([books])=0, 0, ?????)

 

[Guest]

Thanks that helped!

Try use the NZ, It will display the sum of books, and if there are none it
should display 0

=Sum(NZ([books], 0))

--
In God We Trust - Everything Else We Test

I am using unbound text box to sum some information, and if there is nothing
to add I would like the text box to have 0 else the sum of the books. The
following is what I have but am not sure what to put in the ?????
=iif(sum([books])=0, 0, ?????)

 

[Guest]

Thanks that helped!

sum(nz([books])) will work

sam

It would read =iif(sum([books])=0, 0, sum([books]))

But why this way?

If you want to display zero if the sum is zero and sum if it is not zero why
not just sum([books])

I am using unbound text box to sum some information, and if there is nothing
to add I would like the text box to have 0 else the sum of the books. The
following is what I have but am not sure what to put in the ?????
=iif(sum([books])=0, 0, ?????)

 

[artek]

It would read =iif(sum([books])=0, 0, sum([books]))

But why this way?

If you want to display zero if the sum is zero and sum if it is not zero why
not just sum([books])

I am using unbound text box to sum some information, and if there is nothing
to add I would like the text box to have 0 else the sum of the books. The
following is what I have but am not sure what to put in the ?????
=iif(sum([books])=0, 0, ?????)