Create Access like report in Excel.
 

I have data in Access and can export to Excel. I can create an Access Report
or using Word template and Mail Merge to create the same Access report using
detail data from a query.

I also have an Access report with sub totals at 3 group levels. I am
running the report using a query.

I would like to be able to create the 3 group level report in Excel with
appropriate headings and footings using automation from data created in an
Access query and exported to Excel.

Where should I look to get a description of the terminology, process, and an
example?

Jack

Create Access like report in Excel.
 

From your description you are probably best off with a pivot table. This is
similar to a cross tab query in Access. In Excel...

Data - Pivot Table
Wizard comes up
Get data from External Source
Choose Access
Find the Database
Find the Query
Grab the Fields
Save the data in Excel
Define where you want the pivot table to land

Drag the Dimensions (Fields) onto the table.
Lots of option how to arrange and rearrange the data. This is good for up to
about 700,000 records, and you can refresh the data any time. You can also
choose an auto format to make your data pretty.

Look up pivot tables and you should get lots of help... Post back any
specific question you might have though...

HTH

"J-Sherm-Dwyer" wrote:

I have data in Access and can export to Excel. I can create an Access Report
or using Word template and Mail Merge to create the same Access report using
detail data from a query.

I also have an Access report with sub totals at 3 group levels. I am
running the report using a query.

I would like to be able to create the 3 group level report in Excel with
appropriate headings and footings using automation from data created in an
Access query and exported to Excel.

Where should I look to get a description of the terminology, process, and an
example?

Jack