Access convert Table Query Report Form to Report Form

This Access tutorial explains how to convert from one Object to another, such as Query to Form/Report, convert Form to Report.

Access convert Table, Query, Report, Form to Report or Form

There are several kinds of conversion you can do among Access Objects. For example, convert a Form to Report, convert a Query to Form, etc.

Suppose you have created a Query and you want use to print it out as Report, it would be a pain to move everything to the Report. Instead, you can simply do an automatic conversion from Query to Report, but of course the layout may not be what you want, you may need to perfect it in Report Design View.

Access Object Conversion – all possible direct conversion

Because the layout of Query, Form and Report can be very similar, conversion makes much sense. However, not every Object can be convert to one another, I will list out all possibilities in this tutorial.

Convert From To
Table Query
Form
Report
Query Form
Report
Form Report
Report Form

I will demonstrate how to do conversion in Access Excel 2013 in the below tutorial, but if you are using older version, select the object you want to convert, then click on File > Save Object As > select your desired object type.

Access convert Table to Query, Form, Report

Select the Table you need to convert, then click on the Form button to convert to Form, or click on the Report button to convert to Report.

convert_table

The record source of the Form/Report will use the Table.

You may not directly convert a Table to Query, but you can use Query Design or Query Wizard to select the required Table and Field.

Access convert Query to Form, Report

Select the Query you need to convert, then click on the Form button to convert to Form, or click on the Report button to convert to Report.

convert_Query

In this example, we use Query1 as the conversion source. After conversion, the Record Source of the Form / Report is Query1.

Access convert Form to Report

Select the Form you need to convert, then click on the Report button to convert, it does not matter whether your Form is Single Form or Continuous Form.

convert_Report

The Record Source of the Report uses the same Record Source of the Form.

Access convert Report to Form

Select the Report you need to convert, then click on the Form button to convert.

convert_Form

The Record Source of the Form uses the same Record Source of the Report.

Note that if you click on File > Save Object As, you will not be able to convert a Report to Form.

convert_Form2

 

 

Wyman W
Wyman is a Human Resources professional based in Hong Kong, specialized in business analysis, project management, data transformation with Access and Excel.

He is also a:
- Microsoft Most Valuable Professional (Excel)
- Microsoft Community Contributor
- Microsoft Office Specialist in Access / Excel
- Microsoft Specialist in MS Project
- Microsoft Technical Associate
- Microsoft Certified Professional
- IBM SPSS Specialist

Leave a Reply

Your email address will not be published. Required fields are marked *