View Full Version : pivot table and access


yogi
03-26-2007, 01:08 PM
when i create a pivot table with table in access it will only show rows that contains value

ex age 0 1 2
province 11,12,13,14


i want to put a value of 0 if a condition doesnT appear, is it possible?


let presume there is no value for this condition of age 1 and province = 12
how do I make sure that the label would appears all the time if there is no values or that this condition can appear if not met.

thnaks

:)