From the course: Access 2019: Forms and Reports

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Create calculation fields

Create calculation fields

From the course: Access 2019: Forms and Reports

Start my 1-month free trial

Create calculation fields

“

- [Instructor] The majority of our data for our report has been fed in through the record source, either a table or an embedded query, or in the case of our Customer Lifetime Sales report here, a linked query. We can actually calculate values right inside of our report, using unbound text boxes. We're still working on the Customer Lifetime Sales report, and so far we have the layout and conditional formatting in place. Let's add in another level of information in our report by summarizing the data within each State. What I like to do is get a count of how many customers are from each State, as well as a sum total of their lifetime sales per State. Let's take this report into design view to make those changes. First, I'm going to switch over to the Design tab and turn on the Group and Sort window. Then, on the Group on StateName row, I'll click on the More button. And where it says without a footer section, I'm going to change this to with a footer section. This will give us a good…

Contents