Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Feb 2012
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    What is the TEXT command

    I found this in a report and needed to know what it does?
    IIf(IsNull([COST]),"",[text221])
    What does this do? [text221]

  2. #2
    3 Star Lounger
    Join Date
    Apr 2002
    Location
    Redditch, Worcestershire, England
    Posts
    223
    Thanks
    0
    Thanked 21 Times in 20 Posts
    Quote Originally Posted by paweaver View Post
    I found this in a report and needed to know what it does?
    IIf(IsNull([COST]),"",[text221])
    What does this do? [text221]
    It looks like the contents of a text field called text221. Do you have an object on your report with that name? It's not very meaningful, which suggests it's the default name of a textbox or something which has been added to the report.

  3. #3
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,513
    Thanks
    3
    Thanked 47 Times in 47 Posts
    I agree with Jeremy - and the fact that objects like that typically start with text1 suggests you have a very complex report.
    Wendell

  4. #4
    New Lounger
    Join Date
    Feb 2012
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts
    After a good nights sleep and your comments. The answer is..
    Seems to be a very creative way to have both a Calculated Field AND a Running Total in a Report.
    Used in a calculation [text226] = [text225]*([rate]*0.001)
    Running Total [text227] = [text225]+[text226]

Posting Permissions

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