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

From: Kevryl (Kevryl_at_discussions.microsoft.com)
Date: 12/17/04 

Date: Thu, 16 Dec 2004 18:11:10 -0800

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

  • Re: Report question
    ... I typed it in the report and in another report just to see what would happen ... with the actual error message. ... invalid character or omitted something ... set control source property to ...
    (microsoft.public.access.gettingstarted)
  • Re: drivers maybe causing trouble
    ... move forward I need a copy of that Report. ... Disable automatic restart on system failure. ... Check for variants of the Stop Error message. ... for scanning for bad drivers. ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: Error message
    ... I found an entry in bottom> section of "do not report errors for these programs" and> had one listed with a tick on it but the line was blank. ... Computer returned next day as it would power on>>and before windows would normally be on screen just went>>blank screen. ... >>I was then able to reboot the computer without any>>further error message on that day. ... Have looked in Event Manager and see a log>>of the errors and when they occurred reorts error in>>category 102 and event 1003 would presume this would>>relate to a device driver. ...
    (microsoft.public.windowsxp.general)
  • Re: drivers maybe causing trouble
    ... Disable automatic restart on system failure. ... Check for variants of the Stop Error message. ... You were sucessful but next time please provide only one copy of the Report. ... for scanning for bad drivers. ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: Issues with connecting from .NET to Sybase ASE 12
    ... provider for Sybase as well if it can be made to work. ... > when I add fields to a table control on the layout tab and then try to ... > An error has occurred during report processing. ... I receive the same error message. ...
    (microsoft.public.dotnet.framework.adonet)