From the course: Microsoft Access: Forms and Reports

Unlock the full course today

Join today to access over 24,700 courses taught by industry experts.

Create calculation fields

Create calculation fields

From the course: Microsoft Access: Forms and Reports

Start my 1-month free trial Buy for my team

Create calculation fields

“

- [Instructor] We're still building our Customer Lifetime Sales report, and so far, we've got the layout and conditional formatting in place. Let's add in another level of information to our report by summarizing data within each state. What I'd like to do is get a total count of how many customers we have in each state and the sum total of all of the sales within state. To keep things clean, we'll do this in a state footer and place the calculations there. Let's take the report into Design view again, then in order to add in a footer section, we need to turn on the Group and Sort panel. We currently have a group on CustomerState. If I click the More button, you'll see that we have a header section here. I can also turn on a footer section by changing Without a Footer Section to With a Footer Section. That adds this additional section into the report. So now, when the report renders, we'll have a header for each state,…

Contents