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

    Iff Statement (2000)

    Looking to abreviated a field. The field has three options, Sole Selling Rights, Sole Agency and Multi Agency

    What I want to do is have a field in the query that abreviates the options, SSR, SA and MA. How is this achieved?
    Best Regards,

    Luke

  2. #2
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Iff Statement (2000)

    The IIF version would be:

    iif([YourField]="Sole Selling Rights","SSR",iif([YourField]="Sole Agency","SA","MA"))

    You could also create a table that has the options with the abbreviations in it. This way if there were more than just the three, you could add them into the table instead of having to alter you nested IIF.

Posting Permissions

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