I need to attach an Expression to a unbound text box that says.....

IIf([Quantity Sold]=0,0,=Sum([Quantity Sold])) is the syntex wrong!

But it's not working...basically I have an Unbound Textbox That Sums up
the total of Quantity Sold. But If I don't have a record, the field
comes up blank all though I still have a number that should go in there,
like the starting Inventory. Once I put a record in, it works fine.

Thanks
DS

Try this:

=Sum(Nz([Quantity Sold], 0))


--

Ken Snell
<MS ACCESS MVP>

"DS" <bootybox (AT) optonline (DOT) net> wrote

Ken Snell wrote:

What does the NZ stand for?
DS

The Nz function converts a Null to the value that you specify. So, if the
value of [Quantity Sold] field in any record is Null, a zero is substituted
for the Null. If there are no records at all, the Null value is replaced by
zero.

--

Ken Snell
<MS ACCESS MVP>

"DS" <bootybox (AT) optonline (DOT) net> wrote