Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2013

    Unanswered: IIf with DMax in a query not working

    Hello All,

    I normally find answers reading forums but this time I am stuck. Now begging for help

    I attached a screenshot of my latest attempt (tried a couple of things, never good...).

    With it I receive the following error:

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

    I understand there is an issue with "Category", but I don't know how to resolve the case.

    Thanks for some advises,

    Attached Thumbnails Attached Thumbnails Capture.PNG  

  2. #2
    weejas is offline Grumpy old man (training)
    Join Date
    Sep 2006
    Surrey, UK
    Provided Answers: 17
    Try putting the name of the source object for [Category] in front of it in the third argument.
    10% of magic is knowing something that no-one else does. The rest is misdirection.
    Beers earned: 2

  3. #3
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    just to expand on weejas's diagnosis
    [copy of SimpManuShareQuery].[Category]
    should fix the problem
    I'd rather be riding on the Tiger 800 or the Norton

  4. #4
    Join Date
    Jun 2013
    Thank you for the replies.

    He did not work. But I found a way to bypass the issue. I don't know if it is the best option, but at least I can now progress on my task.

    What I did is to use the query to create a new table. I re-queried from the newly created table and it is all fine.

Posting Permissions

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