Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003

    Unanswered: using value in qry col 10 to calc col 5 value

    my qry has 2 tbls tblA leftJoin tblB
    qry has 11 columns

    10 columns from tblA
    1 column from tblB (colB)

    tblA columns are listed 1st then colB from tblB

    what i need to do is
    in the 5th column of the qry call it col5
    iif(colb not is null, colB, 0)

    hope that makes sense

  2. #2
    Join Date
    Oct 2003
    ha ha cool i did it!!

    iif(isnull(colb),0, colB)

Posting Permissions

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