Create a report from scratch

Creating a report by dragging fields

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 task pane.

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.

Topic 6 of 10

Previous | Next

(Back to Start)

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!