Create Access like report in Excel.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automation of Excel Report using Access Data 5
Can't create a report from my query in Access 1
export excel chart to image from C# without using interop 0
manipulate other program using excel macro 2
Access #Error & Excel Pivot 0
How do you embed Access Report in Excel? 3
Access Report 1
Access Access Report Works on One Machine but not Another 3

Back
Top