NZ #ERROR Working

  • Thread starter Thread starter DS
  • Start date Start date
D

DS

To everyone that helped. Thank you!
I got it to work, How though makes no sense. I moved the Calculated
Textbox off the Subform and onto the Main form and refernced back to a
control that doesn't exsist on the first Subform..

=IIf(IsNull(Forms!Orders.[Order Details]![Mod Price]),0,DSum("[Mod
Price]","Mods Detail Query","[Order ID] = " & [Order ID]))


Mod Price doesn't exsist on the Order Details form, so how this is
working I don't know! But it is.
Thank You
All
Again
DS
 
I'm glad it's working but if the calculated textbox is now on the Main form
this should work:

=nz(DSum("[Mod Price]","Mods Detail Query","[Order ID] = " & [Order ID]),0)

I'm surprised you're not getting an error trying to reference something that
doesn't exist.


| To everyone that helped. Thank you!
| I got it to work, How though makes no sense. I moved the Calculated
| Textbox off the Subform and onto the Main form and refernced back to a
| control that doesn't exsist on the first Subform..
|
| =IIf(IsNull(Forms!Orders.[Order Details]![Mod Price]),0,DSum("[Mod
| Price]","Mods Detail Query","[Order ID] = " & [Order ID]))
|
|
| Mod Price doesn't exsist on the Order Details form, so how this is
| working I don't know! But it is.
| Thank You
| All
| Again
| DS
 
DebbieG said:
I'm glad it's working but if the calculated textbox is now on the Main form
this should work:

=nz(DSum("[Mod Price]","Mods Detail Query","[Order ID] = " & [Order ID]),0)

I'm surprised you're not getting an error trying to reference something that
doesn't exist.


| To everyone that helped. Thank you!
| I got it to work, How though makes no sense. I moved the Calculated
| Textbox off the Subform and onto the Main form and refernced back to a
| control that doesn't exsist on the first Subform..
|
| =IIf(IsNull(Forms!Orders.[Order Details]![Mod Price]),0,DSum("[Mod
| Price]","Mods Detail Query","[Order ID] = " & [Order ID]))
|
|
| Mod Price doesn't exsist on the Order Details form, so how this is
| working I don't know! But it is.
| Thank You
| All
| Again
| DS
Click to expand...
Just tried your code..doesn't work. This weird that something that
makes no sense works, and something that does doesn't!
Thanks
DS
 
Back
Top