cross tab query report

[alkrm]

hi,
i created a report based on a cross tab query ,
i have these fields , stock as a row., duration as a colum and deals as data.
the duration is divided in to 1, 3, 6 ,9 and 12 months.
where there is no deals for 12 months for example, this ERROR msg comes :
the Microsoft Data base Engine does not recognize'[12]' as a valid field name or expression .

IS THERE IS ANY WAY TO SOLVE THIS , TO MAKE THE REPORT RUN FOR THE REST THE DATA ???

thnx in advance

 

[alkrm]

Solved

hey , i solved it

using the Colume Heading setting in the cross tab query properties.

i inserted the heading of duration , as "1","3","6","9","12"
and it works.

thnx