create report from crossquery

[stelios]

hi,
i have a cross query by which i have made a report. But when a value in the
column header, in the query, is empty and I open the report I get an error
message that "The Microsoft Jet database engine does not recognize <name> as
a valid field name or expression. (Error 3070)". How can I omit a field
which I have in a report when its value there isnt in the query to bypass
the error?
thanks in advanced, stelios
ps.: sorry for my bad expression in English

 

[Roger Carlson]

Creating reports from crosstab queries is always problematic. On my website
(see sig below) is a small sample database called CrossTabReport.mdb, which
illustrates one way to do it.