Question of How to Make a Certain Report

[colemanj4]

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.

[Larry Linson]

"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