total of subform's subtotals

  • Thread starter Thread starter Chris Ryner
  • Start date Start date
C

Chris Ryner

I have frmTENANTMST with a subform RENTONLY (frmRENT) and a subform
ADDTIONAL (frmADDER).

both of the subforms have subtotal's in the footer: textboxes
SubtotalRent: =sum([sqft]*[rate]) SubtotalAdder: =sum([qty]*[rate])

then on the parent form I need a textbox to display the total of the two
subtotals.

TOTAL: = ([frmADDER].[form]![subtotaladder]) +
([frmRENT].[form]![subtotalrent])


I have tried adding NZ to the subtotals and to the total to no avail.

When both of the subforms have records there is no problem but when one or
both have no records the TOTAL displays as #Error.


What Can I do?
 
I was having similar problems querying totals form
subforms, especially were it was not necessary to fill in
a subform. Check the relationship properties in the query,
and change it so that all of the parent records are
displayed.
 

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

Similar Threads

update textbox with total 9
Empty Subform is a crazy !! 2
Sub Total Not Carrying Over 3
Make Row Total appear in Sub Form 1
Null Value in Subform Total 4
subform total behaving strangely 2
referring to Subform Total in main form 1
SUBFORM SHOWS A NEW "BLANK" RECORD 1

Back
Top