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

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Duane Hookom (duanehookom_at_NO_SPAMhotmail.com)
Date: 12/17/04 

Date: Thu, 16 Dec 2004 20:19:55 -0600

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 

-- 
Duane Hookom
MS Access MVP
"Kevryl" <Kevryl@discussions.microsoft.com> wrote in message
news:2BB73DC2-31C8-4A35-BD4D-0FD0A68C06F7@microsoft.com...
> 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

Relevant Pages

  • HTTP 500 - Internal server error - Internet Explorer
    ... The error message says to refer to the event log for more ... >Server Application Error ...
    (microsoft.public.inetserver.iis)
  • Re: Limit on File Size Upload?
    ... > A user wants to upload an 82MB file to her WSS site. ... > the below error message, ... > refer to a nonexistent file or folder, or refer to a valid file or ... > folder that is not in the current Web. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Can not save relationship
    ... It would help us better assist you if you could include table DDL for both ... (For help with that refer to: ... Most good judgment comes from experience. ... gettitng this error message. ...
    (microsoft.public.sqlserver.tools)
  • Re: Server Application Unavailable
    ... There are many reason for the error message.Please refer to the following ... FIX: You receive a "server application unavailable" error message in the ...
    (microsoft.public.windows.server.sbs)
  • Please help me with this error messages
    ... i have something to refer regarding the error message coming from Advance ... Refer to your getting started manual for more information on ... The above error will suddenly occur during normal operation. ... since this is our main server. ...
    (microsoft.public.win2000.advanced_server)