create report from crossquery

  • Thread starter Thread starter stelios
  • Start date Start date
S

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