Results 1 to 4 of 4
  1. #1
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    More than one alternative under format (2002)

    Hi,

    I have a report that has the following in the format section of the controls on the report: 0%;;;0%. This is working fine. There will be instances where there is an NA in the control not a 0%. Is there a way to write the format piece so that it looks for and returns results for more than one alternative. IE if 0% than 0% else if "NA" than "NA".
    Thanks!

    Leesha

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: More than one alternative under format (2002)

    The format 0%;;;0% is for numeric data type.
    How could you have "NA" in a numeric field or textbox ?
    Francois

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

    Re: More than one alternative under format (2002)

    Your format works for a number field, but if it may contain "NA" it must be a text field, so the number format won't work any more.

  4. #4
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: More than one alternative under format (2002)

    Hi Francois,

    I realize now that I can't use NA in this field due to the number/text issue. I'll just chalk it up to another learning experience.

    Leesha

Posting Permissions

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