Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Test a range (2003)

    How do I test part numbers in a range. I want to know if a part number is say 1Z5,1Z6, or 1Z7. Also, how would I test if a part number is say one of 3 numbers (1Z3,1Z7,1Z11). All these are expressions I need to hide statements on a report.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Test a range (2003)

    You can use the expression
    <code>
    In ("1Z3","1Z7","1Z11")
    </code>
    in the Criteria line in a query.

  3. #3
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Test a range (2003)

    How would I do it on a report. I want to put a statement "Tested" on a report, but only if the Part No is 1Z1,1Z2, or 1Z3, or in some cases 1Z3,1Z7, or 1Z11.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Test a range (2003)

    Place a text box in the detail section of the report.
    Set its Control Source to
    <code>
    =IIf([Part No] In ("1Z1","1Z2","1Z3"),"Tested","")
    </code>
    You can modify the list of part numbers as needed.
    The condition "or in some cases" is too vague to use.

Posting Permissions

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