View Single Post
  #3  
Old June 3rd, 2010, 07:20 PM posted to microsoft.public.access
sternb
external usenet poster
 
Posts: 4
Default #### in Access Pivot Tables

The numbers are formatted correctly and the pivot table looks fine until I
look at it in Print Preview. Then many of the numbers change to the ####
symbols and print with the #### symbols showing.
--
sternb


"Daryl S" wrote:

Sternb -

What should the data look like? (How big are the numbers?) And how many
#s do you see in the widened column?
You may want to format your data - are you showing both comma and decimal
separators as well as maybe a currency symbol and/or brackets for negative
values? They all take up room. Expand the column very wide until you get a
value you can see - maybe there is an error in a calculation or something
that is returning numbers much larger than you expect?

--
Daryl S


"sternb" wrote:

I have an Access 2007 pivot table and can't seem to get rid of the ### signs
showing instead of my values showing. I have widened the columns but am still
having problems. Help!
--
sternb