NZ #ERROR Working

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
 
D

DebbieG

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
 
D

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
Just tried your code..doesn't work. This weird that something that
makes no sense works, and something that does doesn't!
Thanks
DS
 

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

Top