Adding field - error "More than one field...."

G

Guest

On 2 or 3 occasions in the database I'm putting together, I have attempted to
add a field to a report and received the error message:

"The specified field 'Name of field' could refer to more than one table
listed in the FROM statement of your SQL statement".

I click "Help" but only get a totally blank Help window that usually hangs.
The error message gives no clue as to how to troubleshoot the issue and on
eachg occasion I have had to rebuild a report from scratch if I wanted to add
a field from another table.

In adding the field on each aatempt I have invoked the "Expression Builder"
from the Control Source property in the Fields property box, selecting the
table and then the field by double-clicking. On each oocasion the message
has been incorrect, in that it couldn't possibly refer to more than one table.

Has anyone worked through this one?

Keith
 
D

Duane Hookom

Sounds like a very correct statement. I expect you are using a duplicate
field name in an expression an are not using syntax like
Table!Field or Table.Field
 

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
Displaying Text field from linked Excel table in reports 3
query runs - report has error 4
Message: refer to more than one table 1
Adding new fields to an old report 1
Pie Chart -- More than one Field/Series?? 2
How to add field to report from the bound table? 1
Error: Specified field refers to more than one table 6

Top