Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    Mar 2005
    Location
    Leicestershire, United Kingdom
    Posts
    506
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Everything else in a Iff statement (2000)

    Hi,

    I hav the following expression based upon the criteria for the field 'Status'

    IIf([tblProperty]![status]="to let","Rental Applicant",)

    I want to state that if the result is false then the status can be anything. How do I achieve this?
    Best Regards,

    Luke

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

    Re: Everything else in a Iff statement (2000)

    This?

    IIf([tblProperty]![status]="to let","Rental Applicant","Anything")

    If that is not what you want, please attempt to explain what you do want.

  3. #3
    4 Star Lounger
    Join Date
    Mar 2005
    Location
    Leicestershire, United Kingdom
    Posts
    506
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Everything else in a Iff statement (2000)

    Sorry for not making it clear.

    The field 'Position' which is where this iif statement is going in the criteria section has a value list of 6 items. I want to return that if it is not a property with a status of to let, then the position field can have a value of anything except 'rental applicant'
    Best Regards,

    Luke

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

    Re: Everything else in a Iff statement (2000)

    I'd do this differently, without using IIf.

    In the first Criteria row, enter "To Let" in the Status column and "Rental Applicant" in the Position column.
    In the second Criteria row, enter <>"To Let" in the Status column and <>"Rental Applicant" in the Position column.

Posting Permissions

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