If you don't like the results you get with the Report tool, you can use Layout view to build a report manually, a process that gives you more control. You drag fields from a list, arrange them to your liking, and group them.
On the Create
tab, in the Reports group, click Blank Report
. Access creates a blank report and displays the Field List
In the Field List
task pane, open the table you want to use as a data source, then drag fields to the report. Access automatically uses the tabular layout.
If you want to use a different layout, highlight the fields in the report by clicking the Layout Selector, the cross in the upper-left corner of the layout, and then...
On the Arrange
tab, in the Table
group, click Stacked
. Access rearranges the fields.
If that seems a bit complex, don't worry. You'll get a chance to try this during the practice.