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
to do this.
NUMBER]=" & [ORDER NUMBER])
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
return a value i want it to display 0. I am not sure how-----Original Message-----
I have the following formula in my query. If it does not
to do this.
SHIPPED]","[SHIPPER SUBFORM]","[SHIPPER SUBFORM]![ORDERAny help would be greatly appreciated.
TOTAL QUANTITY SHIPPED: DSum("[QUANTITY
NUMBER]=" & [ORDER NUMBER])