Create an Access report with a Datasheet view
When you create a report in Microsoft Access with a Datasheet view, you create a linked table with the data in the Datasheet view and generate a report based on the data.
- In the Datasheet view toolbar, click Task Pane to display the Task Pane for the Datasheet view.
- Click Report with Access.
- Choose to export the Datasheet to an existing database or a new database and click OK.
Access prompts you to specify the location of the database and opens a linked table with the exported data. It uses AutoReport to generate a report that displays all the fields and records in the linked table. For more information on AutoReport, see "Create a report" in Access help.