Report from Crosstab query

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

Win2000
Access 2000

I have a report bound to a Crosstab query. The Crostab query, naturally, has
different fields often when it is run. Is it possible to bind a report to it
and have the report handle the error when it doesn't find a field it was
expecting?

I tried On Error Resume Next in the Report_Open event.
I tried On Error Resume Next in the Report_NoData event.

I think the [HasData] will not work either, because it's not a question of
whether the field has data, but rather if the query returns the field. If a
field isn't found, I'd like to leave it blank on the report.

=IIf([HasData],Count(*),"No Items")
 
Back
Top