Report based on a cross-tab query

[jamesk1979]

Hi all,

Is it possible to have a report based on a cross-tab query which does not produce a message like this;
"The Microsoft Jet database engine does not recognise '[User 1]' as a valid field name or expression."
when there is no records to count for User 1 against the row value?

I have a cross-tab query with a row heading (type), a column heading (user) and using another field (product) as the value.

The problem is I get the above error message in the Report when there is no value for the user against the type. Does this mean that I cannot specify the report format unless I have at least one record to count in each row/column.

 

[dhookom]

You can add all the possible column heading values into the Column Headings property of the crosstab query. There are some other samples of crosstab report solutions at

http://www.invisibleinc.com/divFiles.cfm?divDivID=4.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.