M
Manuel
I have a macro, which prints a report (let's call it
report 1). The report is based on a crosstab query, which
counts "X, Y and Z" (for simplicities sake) values in a
table. However, sometimes there's no "Z" to count, and I
get error message 3070 -
"The Microsoft Jet database engine does not recognize 'Z'
as a valid field name or expression"
- when printing/opening the report.
What I've done is create an identical report (let's call
it report 2) which only counts "X and Y". But now I'm
having trouble altering my macro to print the 2nd report
when error 3070 materializes as a result of printing
report 1.
Anyone have any suggestions? I've tried setting a
condition using the Error Handling functions, but so far
no luck.
report 1). The report is based on a crosstab query, which
counts "X, Y and Z" (for simplicities sake) values in a
table. However, sometimes there's no "Z" to count, and I
get error message 3070 -
"The Microsoft Jet database engine does not recognize 'Z'
as a valid field name or expression"
- when printing/opening the report.
What I've done is create an identical report (let's call
it report 2) which only counts "X and Y". But now I'm
having trouble altering my macro to print the 2nd report
when error 3070 materializes as a result of printing
report 1.
Anyone have any suggestions? I've tried setting a
condition using the Error Handling functions, but so far
no luck.