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 the report structure

Create the report structure

From the course: Access 2019: Forms and Reports

Start my 1-month free trial

Create the report structure

“

- [Instructor] We're working on creating a profit summary report, and step one, gather the data with a query, has been completed. Now it's time to start establishing the structure of the report itself. Let's come up to the Create tab, and in the Reports section, I'll choose Report Design. Then we need to connect this report to its record source, so I'll open up the property sheet, and on the Data tab we'll find the Record Source property. Using the dropdown menu, I'll choose the Profit Summary query that we created in the last movie and then go ahead and close the property sheet. Next, we need to set up the main structure of our report, and we can do that through the Group & Sort window. I'll toggle that on, and come down to the window at the bottom of the screen. We're going to add a number of different sections here to the report. First, I want to group all of my records based off of the year, so I'll choose Add a Group and then choose Year. I want this to be in a reverse…

Contents