DSUM

A

Anne

Hi -

You probably want the Nz function, that allows you to
specify whatever you want to return if the value is null,
so
nz(null, 0) = 0
nz(3,0) = 3

In your case:
nz(DSum("[QUANTITY SHIPPED]","[SHIPPER SUBFORM]","[SHIPPER
SUBFORM]![ORDER NUMBER]=" & [ORDER NUMBER]),0)

- Anne



-----Original Message-----
I have the following formula in my query. If it does not
return a value i want it to display 0. I am not sure how
to do this.
Any help would be greatly appreciated.

TOTAL QUANTITY SHIPPED: DSum("[QUANTITY
SHIPPED]","[SHIPPER SUBFORM]","[SHIPPER SUBFORM]![ORDER
NUMBER]=" & [ORDER NUMBER])
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top