Message: refer to more than one table

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.
 
M

Mike B

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The specified Field Could refer to more than one table... Access 2 5
The specified field name could refer to more than one table listed in the from clause of your SQL st 1
Error message 1
more than one table listed in from clause of sql 3
Error message when trying to generate report 1
Adding field - error "More than one field...." 1
query runs - report has error 4
Specified field could refer to more than one table error message 1

Top