Empty report field problem.

[SQLBI]

Hi,

I have an Access 2k report, bound to a Cross Tab query which shows monthly values and a total for a number of criteria.

My problem is that i may want to run this report for example upto June, however the controls on the report for July - December show an error value.

I've tried using

IIF(IsError([7])=True,0,[7])

but it doesn't seem to work.

Any assistance would be appreciated.

Thanks in advance.




Leigh Moore
Solutions 4 MS Office Ltd

http://www.solutions4msoffice.co.uk

 

[dhookom]

Would it work to set the crosstab Column Headings property to:
Column Headings: "1","2","3",..."12"
Another method would be to use code to hide the non-existing month columns.

Duane
MS Access MVP