Duplicate alias problem

  • Thread starter Thread starter Lawrence Price
  • Start date Start date
L

Lawrence Price

Greetings,

We have a mature Access database with a number of reports that we
usually run every month. This month we experienced a problem. When we
tried to run one of the reports we got an error message - "Duplicate
output alias 'Expr1'. " The resolution to this problem suggested a
problem with the underlying query and to change it. This was not
helpful because we've made no changes to the report for over a year.

Any help would be appreciated. Thanks.

Lawrence Price
 
Lawrence Price said:
Greetings,

We have a mature Access database with a number of reports that we
usually run every month. This month we experienced a problem. When we
tried to run one of the reports we got an error message - "Duplicate
output alias 'Expr1'. " The resolution to this problem suggested a
problem with the underlying query and to change it. This was not
helpful because we've made no changes to the report for over a year.
Click to expand...

This sort of thing is hard to debug remotely like this, but it sure
sounds like someone has changed one of the following:

1) the report's RecordSource property
2) a stored query that is used by the recordsource
3) a table that is used by the recordsource or a query that it uses.

Even though the report itself may not have been touched, it may be that
an underlying table or query has been changed.
 
Back
Top