Results 1 to 3 of 3

Thread: error message

  1. #1
    Join Date
    Dec 2004
    Posts
    6

    Unanswered: error message

    can some one tell me what this error message means and how to fix it:
    "the specified field[ResourceTypeID] could refer to more than one table listed in the from clause"

    thanks

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    It means, in your query you use more than table, which have the same field's name, so you must tell the engine which field do you mean. Therefore you have to use the TableName the a period then the field's name you mean.
    i.e orders.orderNum

  3. #3
    Join Date
    Dec 2003
    Location
    Dallas, TX
    Posts
    1,004

    Talking

    Hi scjohn and "Welcome to the Forum
    Go to your Query in DesignView
    Locate the FieldName that is the one in your ErrorMessage
    Click on the drop down arrow in the QBE grid where it says Table
    Once that drops down, select the correct Table that particular field is coming from. And that should do it.

    hope you enjoy the Forum
    have a nice one,
    BUD

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •