Solved

Subform - Sum Totals

Posted on 2016-09-21
2
48 Views
Last Modified: 2016-09-21
Experts, how do I make the subform in datasheet format, automatically sum as shown?   I have to continually choose the dropdown "Sum" for the column.   I have saved the form as shown in the pic below but it doesnt open with the column summed.

Sum
0
Comment
Question by:pdvsa
2 Comments
 
LVL 35

Accepted Solution

by:
PatHartman earned 500 total points
ID: 41809063
This feature leaves a lot to be desired.  If you want to ensure that the total always populates, add a footer to the subform and add a control that does the summing there.
0
 

Author Closing Comment

by:pdvsa
ID: 41809162
ahhh I see.  I was afraid of that.  OK I can add a field.  Thank you
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question