Report from Crosstab Query

  • Thread starter Thread starter paula
  • Start date Start date
P

paula

If I've set up a report based on a crosstab query that
yields me a full range of columns, and I change the
parameters on the query, if there is an item than has a 0
value, the report will not open (it used to in an older
version!!)
"Microsoft Jet Database engine does not recognize xxx as a
valid field name or expression"
I don't want to have to change the report each time I
change the parameters.
How do I allow for a zero value from the crosstab query in
a report?
 
You need to set the crosstab's Column Headings property to include all
possible column names that will be used.
 
Back
Top