Excel and Access are two software applications which belong to the Microsoft Office suite. You can create a data file in a spreadsheet format using Access and then later open the file and work on. For each 'PointDesignation' record there is a subdatsheet with variable amount of subdatasheet records. I want to create a report displaying all of the data found in the subdatasheet but cant seem to find a way to access the subdatasheet in the report design view.
In the corporate environment, Excel is king. So when you have an Access database report that you would really prefer to analyze in Excel spreadsheet form, there’s an easy way to convert it.
To convert it, start by opening up your Access Report in Print Preview mode.
Make sure you have the Print Preview Toolbar showing. You just need to right click an empty area on your toolbar and select “Customize” and check the toolbar.
From the Print Preview Taskbar click the drop down menu and select “Analyze It with Microsoft Office Excel”.
Your Report will now be in Excel for you to change and analyze the data.
![Access Export Subdatasheet To Excel Access Export Subdatasheet To Excel](https://support.content.office.net/en-us/media/4dbc2361-dafd-4c9e-ba73-1bd2a4a2e892.jpg)
- › How Do Smart Homes Work?
- › What’s Going to Happen to Your Huawei or Honor Phone?
- › Will a Smart Plug Pay For Itself?
- › Hardware Security Keys Keep Getting Recalled; Are They Safe?
- › Google Drive and Photos Are Splitting: What You Need to Know