Can a report be used in Excell? (Imported or Exported)

[Guest]

I was wondering if a report can be either exported to an Excell spreadsheet,
or is it possible to go into Excell and import an Access report?

I'd want to be able to calculate a couple totals for each group of employees
by the supervisor. In other words: Supervisor Ben has five employees, so I
want to add up the stats for the five employees to get Ben's total.
Supervisor James has seven employees, so I want to add their stats to get a
total for James. This can be done in a report, but I would need these
calculated stats for an Excell spreadsheet.

I wasn't sure if these type of calculations could be done in a query, but I
knew they could in a report. Problem is, I know you can use a query in
Excell, but wasn't sure if you could use a report. I have a similar (but
different) question in another board.

--
Have a nice day!

~Paul
Express Scripts,
Charting the future of pharmacy

 

[Duane Hookom]

Have you considered creating an Excel Pivot table from your Access
table/query? Pivot tables provide great slicing/dicing and summarizing of
stats.

 

[Guest]

A pivot table? No, I've never experimented with those before. I'll go see if
I can figure that out. Thanks for the suggestion. I'll either come back to
this thread, or start a new one if I can't seem to figure it out. That may be
of a lot of help if I can get it.

--
Have a nice day!

~Paul
Express Scripts,
Charting the future of pharmacy

 

[Duane Hookom]

Prior to creating the Pivot table in Excel, I create a 'datasource' query in
my Access mdb that joins all the required tables and provides an alias for
each of the column/field names. My table and field names are generally "not
for public viewing". This makes the Pivot creation much friendlier.