Access 2007 Form or Report layout

clchapman
clchapman used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
You can create a crosstab report based on a crosstab query. See http://office.microsoft.com/en-us/access-help/create-a-crosstab-report-HP005187407.aspx
You can do that using a Pivot Table. Place AppGroup in the Rows, SecProfile in the Column and the rest in Data group. See tblYourTablePivot of the attached.

Flyster
PivotTable.accdb

Author

Commented:
Thank you, the link provided a good starting point.

Commented:
You're welcome!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial