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

[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

 

[Noëlla Gabriël]

Hi David,

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

 

[David Saywell]

Hi Noella,

Thanks for the reply.

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

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

Hi David,

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

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