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

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
 
Back
Top