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.
 

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

Sub-form totals 3
Sub Forms 3
Sub totals on sub forms 2
Access Form Refresh 1
Expression in Forms 3
Main form with two sub forms 1
Access Sub form opens before the main form in MS Access 0
Grand Total on form shows #error 2

Back
Top