Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    139

    Unanswered: Multiple criteria w/conditional statement

    I'm using an If statement:

    If Me!Mill = "00" Then
    Me!Truck = "Hanes"
    End If

    This works fine...But what I would like to do is specify multiple criteria, such as:

    If Me!Mill = "00" Or "35" or "15" Then
    Me!Truck = "Hanes"
    End If

    But this second statement doesn't work, is there a solution to this w/o writing out each variation in an individual statement?

    Bill
    Thanks,
    Bill

  2. #2
    Join Date
    Feb 2004
    Posts
    137
    Try this:
    Code:
    Select Case Me!Mill
        Case "00", "35", "15"
            Me!Truck = "Hanes"
    End Select

Posting Permissions

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