How to calculate values using subforms (1 Viewer)

[helper11]

Hi all,

I am trying to figure out how to calculate the values of items in the sub forms and place them on the main form. The problem I am running into is if the subforms have any of the calculating boxes empty the total would be empty.

How can I search or work around this so I can total up the items in the subform?

Thanks for your help.

 

[pbaldy]

If you mean within the subform, you can use the Nz() function. If you mean when the subform has no records, I use this:

http://www.mvps.org/access/forms/frm0022.htm

 

[helper11]

Thanks a ton that really did the trick