Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2004
    Posts
    3

    Question Unanswered: Can someone help me with IF statement

    Hi to all


    I have a problem with if statement in Microsoft Access.



    Example:



    SELECT DISTINCT IIf([ A.A_a] Is Null,[ B.B_b ],[A.A_a])
    FROM B RIGHT JOIN (A RIGHT JOIN C ON A.A_aa = C.C_cc) ON B.B_bb= C.C_cc;

    this statement works just good

    And now the problem:
    I have to separate this statement in 3 different fields.
    - SELESCT field
    - FROM field
    - WHERE field

    I already try a few things and it did not work.


    Can anybody help me?

  2. #2
    Join Date
    Jan 2004
    Posts
    3
    P.s. A,B,C are tables

  3. #3
    Join Date
    Aug 2002
    Location
    Northampton, England
    Posts
    266
    You can see what the SQL loks like by clicking on view then SQL view in query design. This should help.

  4. #4
    Join Date
    Jan 2004
    Posts
    3
    I am using the program in vetch you have to separate this statement in those 3 fields. These programs have a problem with left and right join i have to write this statement with no joins.
    And how can I do that

  5. #5
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Originally posted by nippo
    I am using the program in vetch you have to separate this statement in those 3 fields. These programs have a problem with left and right join i have to write this statement with no joins.
    And how can I do that
    You can't.

Posting Permissions

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