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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

julie@inflatable-packers.com.au - 20 May 2008 06:41 GMT

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

Reply to this Message

Roger Carlson - 20 May 2008 13:35 GMT

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

Signature

--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

>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
[quoted text clipped - 5 lines]
> any ideas?
> joolie

Reply to this Message