Sub Form and Form Total

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have records (5-6) in a subform but need the total of the amounts in the
sub form to appear on the form. I have created a Sub Total Box and can get
the sub form and Sub Total field to link but can only get the total of one
sub form record at a time. How can I fix this so that if Sub Record 1 says
£50 and Sub Record 2 says £20, the Sub Total field on the main form will read
£70?

TIA - all help appreciated....(I have a feeling I will be here a lot in the
next few weeks, thanks for any advice)

Cindy
 
Open the Northwind sample database.

Open the Orders form in design view.

Look at how the Subtotal works there, reading the value from the Form Footer
section of the Orders Subform.
 
Back
Top