From the course: Access 2016: 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 2016: Forms and Reports

Start my 1-month free trial

Create calculation fields

“

- [Voiceover] The majority of the data for our report has been fed in through the record source, either through a table or an embedded query or in case of the customer lifetime sales report we've been working on, through a linked query. But we can actually calculate values right inside of our reports using unbound text boxes. Let's come down here and open up that lifetimes sales report that we've been working on. What I'd like to do is come down here to the end of each state, and I'm going to add in a new state footer that'll appear down here. Then inside of that footer, I want to count up how many customers we have and get the sum total for all the money spent within each state. Let's go ahead and add that back in Design View. On the group it's art window, if that's not open, go ahead and press this button up here on the toolbar. We'll come down here to the group and sort on state name. Over here, I'll press the More button. That'll give me some more options to deal with this…

Contents