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

    Question Unanswered: show char on report, based on value

    I get the value 0 or 1 shown on a report.
    If 0 the report must show "AG"
    if 1 the report must show "EG"

    i've tried
    =IIf([OrderType]=1,"EG","AG")
    but get an error #error

    how else can I do this?
    thanks in advance
    ActionAnt

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

    Re: show char on report, based on value

    Originally posted by actionant
    I get the value 0 or 1 shown on a report.
    If 0 the report must show "AG"
    if 1 the report must show "EG"

    i've tried
    =IIf([OrderType]=1,"EG","AG")
    but get an error #error

    how else can I do this?
    thanks in advance
    ActionAnt
    What is the type of the field? If it's a boolean then do:

    =IIf([MyFieldNameHer]=True,"EG","AG")

Posting Permissions

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