I created a crosstab report from a crosstab query using the example from the solutions9 database.
I have one little hang up. If I run the report, I recieve the error "Jet database engine does not recognize '' as a valid field name or expression."
From reading, it appears that the problem is fixed by declaring the column headers in the Column Headings Field of the Query Properties. If I do this, the query and report work great. However, I am looking for a way for the column headings to be created automatically.
Thanks for your help.
I have one little hang up. If I run the report, I recieve the error "Jet database engine does not recognize '' as a valid field name or expression."
From reading, it appears that the problem is fixed by declaring the column headers in the Column Headings Field of the Query Properties. If I do this, the query and report work great. However, I am looking for a way for the column headings to be created automatically.
Thanks for your help.