Skip navigation

On September 14th, 2017, we published revised versions of our Privacy Policy, Terms of Service and Website Use Policy and published a Cookie Policy. Your continued use of means you agree to these revised documents, so please take a few minutes to read and understand them.

Create calculation fields

Create calculation fields: Access 2016: Forms and Reports
Create calculation fields: Access 2016: Forms and Reports

In this movie, Adam adds a calculated field into a footer section of the Customer Lifetime Spend report to summarize the data across the state. Calculated fields use an unbound text box and summarize data across the grouping level they’re inserted into. By placing the calculation in a StateName footer, the box totals the spend amount for each state.

Resume Transcript Auto-Scroll
Skill Level Intermediate
4h 59m
Show More Show Less
Skills covered in this course
Business Databases Access Office Office 365

Continue Assessment

You started this assessment previously and didn't complete it. You can pick up where you left off, or start over.

Start Your Free Trial Now

Start your free trial now, and begin learning software, business and creative skills—anytime, anywhere—with video instruction from recognized industry experts.

Start Your Free Trial Now