Report Design

[Weste]

I am trying to design a report with the layout shown below

Jan Feb
Empl Mgr Dept Fcst Bgt Fcst Bgt
Doe Smith HR 100 70 70 80

The report would display all 12 months Jan – Dec

Is it possible to do this with a printed report or do I need to use a Pivot
report?

I was able to design the Pivot report. However, when I clicked the button
Export to Excel, the data in the detail area was lost (100,70,70,80). Is it
possible to retain this data during the export process?

One last question. How do you programmatically export the Pivot to Excel?
I would like to export the data to a specific network drive.

Thanks for your help!

Weste

 

[Duane Hookom]

You should be able to use a crosstab query. We don't know anything about your
table structure. There are some crosstab report samples at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.