Sum of values on a subform 1

[jlindquist]

I have a form with a bunch of preliminary order information. I then have a continuous subform on this form. Part of that data is "Amount". Part of the original form is the "Total". I want the "Total" on the main form to be equal to the sum of all the "Amount" fields on the subform. Any idea how to do this easily?

 

[JoeMiller]

I have a sample database I can send you that does this if you provide your email address. It utilizes the DSum() function if you want to try and figure it out yourself. Here's the basic format of a DSum expression:

=DSum("[FieldToSum]","QueryOrTableToSumFrom","[Criteria]=[Criteria]&quot

HTH Joe Miller
joe.miller@flotech.net

 

[jlindquist]

Email me at Jon-Paul_Lindquist@cdh.org