missing columns in reports

[neilp]

I have a report that can have upto 10 columns but on some occasions when the report is run there is no data in one or more of the columns which results in the report stopping with the error message

The Microsoft Jet database engine does not recognise 'TRAFFIC' as a valid name or expression.

The query that is used for the report works fine and will only display the columns with data omitting the null columns
Is there a way to allow the report to use the query in such a way that those columns with data are used no matter which they are or inserts a zero in the null columns.

 

[Pat Hartman]

Your report must be based on a crosstab query. The easiest thing to do is to open the query in design view, bring up the properties dialog for the query, and modify the ColumnHeadings property to include all the possible columns:

"TRAFFIC","SomeOtherValue","MoreValues"

This will force the query to return all possible columns even if there is no data for them. Look up the ColumnHeadings property in help for further information.