pivot table results

[kmayo503]

my boss is used to looking at a pivot table from excel for his reports. we have moved our database to access because of the amount of information. i have tried so many different designs of reports is there a way to setup a report to resemble that of a pivot table from excel?

 

[dhookom]

A pivot table report might look a bit like a crosstab report. There are a couple samples in a download at

http://www.invisibleinc.com/divFiles.cfm?divDivID=4.

Duane
MS Access MVP

 

[kmayo503]

that is exactly what i need, but when i tried to set it up the cross tab wizard won't let me pick more than one field. i have 5 fields i need in the report i want. i need 2 fields for row headings and 5 for column headings. i am not sure how to do that. can you help or should i ask someone in querys forum?

 

[dhookom]

Crosstab querys have only one expression/field in the value. There are some of the reports in the CrosstabReportsl.mdb that show how to include multiple values.

Duane
MS Access MVP

 

[kmayo503]

i figured out how to get them to add the other fields i need in design mode, but i can't get the report to look right. i just have to fiddle with it. thanks so much. for the help.