I have a series of reports based on the same query and have been using the reports and the query without problems for several months.
Yesterday I added a table to the query. When viewed, the query operates correctly and generates no error messages.
However, when I run the reports based on the query, I now get prompted to enter a value for Expr1017.
There are no expressions in the query and I do not get prompted to enter the expression value when I run the query from the query window, only when using the reports. The reports themselves are unchanged.
It does not matter whether I enter a value for Expr1017 or not; the report prints correctly in either event.
There is only one field in common between the two tables in the query and neither field is included in the actual report.
I am completely stumped. Any ideas? Thanks!
Yesterday I added a table to the query. When viewed, the query operates correctly and generates no error messages.
However, when I run the reports based on the query, I now get prompted to enter a value for Expr1017.
There are no expressions in the query and I do not get prompted to enter the expression value when I run the query from the query window, only when using the reports. The reports themselves are unchanged.
It does not matter whether I enter a value for Expr1017 or not; the report prints correctly in either event.
There is only one field in common between the two tables in the query and neither field is included in the actual report.
I am completely stumped. Any ideas? Thanks!
