PC Review


Reply
Thread Tools Rate Thread

Can you format a pivot table in Access?

 
 
=?Utf-8?B?U2hhdW4gUnVja2Vy?=
Guest
Posts: n/a
 
      22nd Jun 2006
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?
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
pivot table format Steve Microsoft Excel Misc 1 13th Dec 2007 04:00 AM
format pivot table =?Utf-8?B?Y29uZnVzZWQ=?= Microsoft Excel Worksheet Functions 0 18th Jul 2006 11:03 AM
Link/Bound Pivot Chart to a Pivot Table in Access Form cesemj@cox.net Microsoft Access Forms 1 9th Mar 2006 07:03 AM
Pivot Table Format chickitaflower@earthlink.net Microsoft Access Reports 6 17th Aug 2005 05:11 PM
Pivot table export data to table format Sue Moore Microsoft Excel Misc 1 2nd Sep 2003 11:01 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:28 AM.