Can you format a pivot table in Access?

S

Shaun Rucker

I am trying to create a report or pivot table that displays the dollar amount
of write off's approved by particular managers in particular departments.
Ex.
Dept. Authorized Total
Admin Dana $192.00
Lyzz $265.00
Total $457.00

I have the data displaying exactly as I hope to with a form that I can view
as a Pivot table. However, I need to dress it up a little (add a Header,
Center on the page horizontally and vertically, etc). It doesn't seem that
Access will let me do any of this, aside from simple bold/underline/italic,
etc.

I know I can export the table to Excel and do what I wish, but the reason
for using Access is so I can just pull up the same form every month and don't
have to mess with formatting every time. Is there a way to do this?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top