CrossTab Report

  • Thread starter Thread starter Ann
  • Start date Start date
A

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!
 
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!
 
Back
Top