Several subforms need to do a summary (1 Viewer)

[Joe8915]

I have several different subforms, I have field adding several Textfields in the Form Footer. Now I need to combine all the subforms into one main form and do a summary. I know you can do it in reports such as using the "HasData" method. I could not make it work.

Any ideas on how I can make it work.

using MS Access 10

 

[boblarson]

Use the Nz function around each piece of the equation.