clchapman
asked on
Access 2007 Form or Report layout
Is it possible to create a crosstab report or form? If so, how? For instance, the query includes the following fields: Application, Security Profile, Load, View, New, Open, Save, and Save As. We need the Security Profile displayed across as a Page Header with each access field ( Load, View, New, Open, Save, and Save As) diplayed as row 2 of the Page Header, and the Application field as the row. Basically a pivot table that does not look like a pivot table.
See attached for current query and example of how the client wants the report or form to look. (The reason for a form or report is the client would like specific formatting for presentation.)
SampleData.pdf
See attached for current query and example of how the client wants the report or form to look. (The reason for a form or report is the client would like specific formatting for presentation.)
SampleData.pdf
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you, the link provided a good starting point.
You're welcome!
Flyster
PivotTable.accdb