Pivot Table Form - Display Null Values as "0" on Data Axis?

  • Thread starter Thread starter David Saywell
  • Start date Start date
D

David Saywell

Hi Everyone,

I have a Pivot Table Form in Access 2003 and need the blank/null cells on
the
data axis to display "0". This is easy to do in Excel but I have searched
through all of the options in Access and cannot find it.

What is the VBA code required to set this option?

Can anyone suggest a good reference book or website for coding Pivot Tables
with VBA?

Many thanks,

David
 
Hi David,

can't you use the calculated value NZ([myvalue],0) instead of the value
itself?
 
Hi Noella,

Thanks for the reply.
"can't you use the calculated value NZ([myvalue],0) instead of the value
itself?"
Click to expand...
Click to expand...

I'm not sure... But I don't think so because there is no value to begin
with...

I don't know enough about VBA for Pivot Tables in Access and I'm not sure
how to apply the "Nz" function to the code used to manipulate Pivot Tables
and Pivot Fields etc.

There seems to be very limited documentation on the web and in book form
also, I may need to abandon using Pivot Tables in Access and push the data
to Excel.

Many thanks,

David



Noëlla Gabriël said:
Hi David,

can't you use the calculated value NZ([myvalue],0) instead of the value
itself?
--
Kind regards
Noëlla


David Saywell said:
Hi Everyone,

I have a Pivot Table Form in Access 2003 and need the blank/null cells on
the
data axis to display "0". This is easy to do in Excel but I have
searched
through all of the options in Access and cannot find it.

What is the VBA code required to set this option?

Can anyone suggest a good reference book or website for coding Pivot
Tables
with VBA?

Many thanks,

David
Click to expand...
Click to expand...
 
Back
Top