Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Location
    South Africa
    Posts
    178

    Question Unanswered: displaying text on a report, based on a value

    on my report, there is a field that displays a value, either 1 or 0.
    If 0 it must display A
    if 1 it must display G

    how would I do this?
    thanks in advance
    Actionant

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713

    Re: displaying text on a report, based on a value

    Originally posted by actionant
    on my report, there is a field that displays a value, either 1 or 0.
    If 0 it must display A
    if 1 it must display G

    how would I do this?
    thanks in advance
    Actionant
    Textbox?

    =IIf([ColumnName]=0,"A","G")

  3. #3
    Join Date
    Jan 2004
    Location
    South Africa
    Posts
    178
    thanks but I get an error
    #error

  4. #4
    Join Date
    Jan 2004
    Location
    South Africa
    Posts
    178

    Re: displaying text on a report, based on a value

    Originally posted by M Owen
    Textbox?

    =IIf([ColumnName]=0,"A","G")
    I get an error
    #error

Posting Permissions

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