Message: refer to more than one table

  • Thread starter Thread starter smptooling
  • Start date Start date
S

smptooling

I am generating a report from a query. The query shows
all the data I want to display in my report, but when I
run the report I get the following message:
The specified field
Toolcustom.fieldvalue could refer to more than one table
listed in the FROM clause of your SQL statement.


What can I do to resolve this issue?
Thanks.
 
You have at least two fields in your underlying query that use the same
name.

You can either:
1. Choose not display one of the fields that have duplicate names; or
2. Use an alias name for one of the duplicates
3. Name the control source field, but also include the table name.
(YourTable.YourField)
 
Back
Top