Grand total only takes the first field and does not sum the entiresubform amount

[julie]

I have two subforms in access 2007 which Total fine on their own but
when i try to get a Grand Total for both subforms it only calculates
the first field of each subform. this is what ive used to calculate..

=Nz([QryProductQuoteDetail].[Form]![Cost])+Nz([Replacement Details
Query1].[Form]![Cost])

any ideas?
joolie

 

[Roger Carlson]

Try this;
=Sum(Nz([QryProductQuoteDetail].[Form]![Cost]))+Sum(Nz([Replacement Details
Query1].[Form]![Cost]))

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L