• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 78
  • Last Modified:

Subform - Sum Totals

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.

1 Solution
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.
pdvsaProject financeAuthor Commented:
ahhh I see.  I was afraid of that.  OK I can add a field.  Thank you
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now