Solved

Access 2007 Form or Report layout

Posted on 2014-02-27
4
545 Views
Last Modified: 2014-02-27
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
0
Comment
Question by:clchapman
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 10

Accepted Solution

by:
etech0 earned 500 total points
ID: 39892691
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
0
 
LVL 22

Expert Comment

by:Flyster
ID: 39893047
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
0
 

Author Closing Comment

by:clchapman
ID: 39893628
Thank you, the link provided a good starting point.
0
 
LVL 10

Expert Comment

by:etech0
ID: 39893634
You're welcome!
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question