Results 1 to 2 of 2

Thread: If statements

  1. #1
    Join Date
    Dec 2003
    Posts
    20

    Unanswered: If statements

    Can anyone help on this. I have a field called accrej with 3 choices, "A" "R" and "N". In the IF statement I only want to pickup the "A" and "R" but I don't want to put 2 If statements. Is there 1 If statement I can use.

    Example: If !accrej= "a" then

    and If !accrej= "R" then

    Is the If !accrej= "A" or "R" then

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    it works like this

    with yourRecordset
    if ((!accrej= "a" ) or (!accrej= "R")) then
    'do something
    else
    'do somethingelse
    endif
    end with

    even simpler:
    if !accrej <> "N" then

    izy
    currently using SS 2008R2

Posting Permissions

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