From the course: Microsoft Access: Forms and Reports

Unlock the full course today

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

Create the report structure

Create the report structure

From the course: Microsoft Access: Forms and Reports

Start my 1-month free trial Buy for my team

Create the report structure

“

- [Instructor] We are 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. We'll do that by going to the Create tab and starting a new empty report in Design view. The first thing we need to do is connect it to the data source. So I'll open up the Property Sheet, and I'll go to the Data tab, where I'll find the Record Source property. Using the drop-down menu, I'll connect it to the Profit Summary query that we've just created. Now we can set up the structure of the report with the Group & Sort panel. First, I want to group all of the data together by the year. So I'll add a group, choose by year. And I want it to go from smallest to largest, so that the earlier years are at the top of the report. Then I could add another group to group the records by the month name. Finally, within each…

Contents