Search results

Thankyou tehNellie, If I have a Pivot Table that gives total Sales by Store by Department, not all Stores will have Sales for every Department, this means there will be a blank cell on the data axis. Can you tell me how to apply this code to the Pivot Table? e.g. If I want to hide details...

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...