By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,952 Members | 949 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,952 IT Pros & Developers. It's quick & easy.

Question of How to Make a Certain Report

P: n/a
Hello, I have a query that gives me a list of departments, a list of
Actions Types and a percentage. I would like to get it into a report
that has the Departments listed down the left side, the Action types
listed across the top and the correct percentage in the proper square.
Is there a way to do this with Access (I am usin Access 2002).

Any help you could provide would be greatly appreciated.

Mar 21 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a

"colemanj4" <co*******@gmail.comwrote
Hello, I have a query that gives me a list
of departments, a list of Actions Types and
a percentage. I would like to get it into a report
that has the Departments listed down the left
side, the Action types listed across the top and
the correct percentage in the proper square.
Is there a way to do this with Access (I am usin
Access 2002).

Any help you could provide would be greatly
appreciated.
Check Help for Cross-Tab Query and for Pivot Tables. Those are the features
Access provides for doing what you want.

For anyone to give you more detail, they would need more detail on the data
you have, and how it is stored and/or on what your query produces. "List
of" doesn't give us a really good feel...

Clarify and perhaps someone can offer a useful suggestion.

Larry Linson
Microsoft Access MVP
Mar 22 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.