The specified field could refer to more than one table listed in the FROM clause

Explore Related Content On "Microsoft Access"

• Hot Articles & Questions on "Microsoft Access"
• The specified field could refer to more than one table error with curious but inadequate f
• The skinny on Access Add-In creation:
• The size of my data base does not change
• the size of an single project
• The size of a tick box?
• The shortest report
• The SHIFT key
• the setting for the DecimalPlaces error in a ACC2003 project
• The Second Commandment (of Access)
• The search key was not found in any record. (Error 3709)

• Open Articles & Questions on "Microsoft Access"
• The space between to pages
• The Solution to the Problem
• The software needed to build a fully functional online hotel reservation system
• The Sleep() function
• The sendobject command using netscape mail
• The sendobject command does not fill out the email address in nets
• The search key was not found in any record?
• The search key was not found in any record. (Error 3709)
• The search key was not found in any record. (Error 3709)
• The Search Key was not found in any Record.

All Comments

Leave a comment...

• 3 Comments
• • 
  • You have (accidentally) posted this question in the Access Articles section. This is NOT an article.

    I'm moving this to the main Access questions forum.

    MODERATOR.

    #1; Fri, 04 Jan 2008 17:31:00 GMT
• • 
  • I suspect this is quite straightforward, but posting a copy of the SQL that is triggering the error message would prove helpful.

    From there we can tell you precisely what to fix.

    #2; Fri, 04 Jan 2008 17:32:00 GMT
• • 
  • You'll have to "qualify" the field [contractnum] as it's apperently part of two tables.

    Let's assume you have the tables tblA and tblB, then use e.g.:

    [tblA].[contractnum]

    When it's tblA having the needed value. For a full (INNER) join the table won't matter, but when you have an outer (LEFT or RIGHT) join (there's an arrow displayed instead of a line), then make sure you use the "master" table to qualify the field

    Nic;o)

    #3; Fri, 04 Jan 2008 17:33:00 GMT