Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2008
    Posts
    2

    FROM Clause error message

    I am trying to write an expression for the following fields:
    Date
    Customer
    Job_Number
    Product
    System
    Revenue
    Category
    Team

    The expression that is giving me the error message is:



    TEAM: IIf([CATEGORY]="EAST" And [PRODUCT]="SURFACE_PREP" And [SYSTEM]="WATERBLAST","BIRMINGHAM","HOUSTON")

    The error message says: "The specified field '[SYSTEM]' could refer to more than one table listed in the FROM clause of your SQL statement."

    I've searched this forum as well as Access Help and can't figure out what's causing this error. Any help would be greatly appreciated!!

    Thanks!

  2. #2
    jya is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Sep 2007
    Location
    Chicagoland
    Posts
    109
    Are you using more than one table in your query? Whenever I've seen this message, it's because I had two different tables with the same field name. I've fixed it by putting the tablename in front of the field name.

    ex. [Table].[System]

  3. #3
    Join Date
    Oct 2008
    Posts
    2
    That fixed it - thanks for the help!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. IIF clause
    By Peljo in forum Queries
    Replies: 2
    Last Post: 02-05-2008, 11:22 AM
  2. "Overflow" error message.
    By joeferraro2000 in forum Queries
    Replies: 0
    Last Post: 03-08-2007, 06:36 PM
  3. Replies: 1
    Last Post: 07-17-2006, 06:30 AM
  4. If / Then Error Message
    By Schwagr in forum Forms
    Replies: 4
    Last Post: 03-30-2006, 06:28 AM
  5. Help on WHERE clause
    By QBCM in forum Programming
    Replies: 1
    Last Post: 12-19-2005, 08:43 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums