CrossTab Report

[Ann]

I have report based on a crosstab query. It sums items
for three categories...Simple, Moderate, and Complex. The
problem I'm having is - if there are no Complex records
(or any other category) I get an error stating "The
Microsoft Jet database engine does not recognize " as a
valid field name or expression" and the report will not
run. Is there any way around this?

Any suggestions are greatly appreciated!

 

[FRED]

Put your column name In the query parameter "column headings"

Ex.: "columns paramters" = "Simple","Moderate","Complex"

If there is no Moderate the column will print without any data.


FRED

----- Ann wrote: -----

I have report based on a crosstab query. It sums items
for three categories...Simple, Moderate, and Complex. The
problem I'm having is - if there are no Complex records
(or any other category) I get an error stating "The
Microsoft Jet database engine does not recognize " as a
valid field name or expression" and the report will not
run. Is there any way around this?

Any suggestions are greatly appreciated!

 

[Ann]

That worked! Thank you so much!!!