Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Thanked 0 Times in 0 Posts
    I am having a heck of a time with query logic. I am using the following:

    Drug: IIf([Component_Type_Code] And [Product_Type_Code] Is Null,"No","Yes")

    Everything is coming out "Yes" even though Component_Type_Code and Product_Type_Code are null.

    I used

    Drug: IIf([Component_Type_Code] And [Product_Type_Code] ="","No","Yes")

    That gives me an #Error and where it should equate to "No" it says "Yes" (where Component_Type_Code and Product_Type_Code are null).

    What am I doing wrong???

    I figured it out:

    Drug: IIf([Component_Type_Code] is Null And [Product_Type_Code] Is Null,"No","Yes")

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts
    Topic closed by HansV because the problem has been solved by the poster herself.

    PM me (or another moderator for this forum) if it should be reopened.

Posting Permissions

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