Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2004
    Posts
    287

    Unanswered: Grabbing/Displaying Report Data

    I have a report that uses a Priority field of 0 or 1
    But I want to display text for either 0 (Low) or 1 (High)
    How can I do this as I have attempted to use some VB Code OnOpen of the rport but it states 'You entered an expression that has no value"?

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    either as part of the query
    iif([priority]=0,"Low","High")

    alternatively you could use conditional formatting to set a colour
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Mar 2004
    Posts
    287
    would i place this in the criteria for the query or on the report page? (onopen, etc..)

    also, to add i have attempted Conditional Formatting but it states the same error.
    Can you explain both methods and where to place the code please?
    Last edited by NeilMansell; 04-17-07 at 10:08.

  4. #4
    Join Date
    Mar 2004
    Posts
    287
    any help on this would be appreciated as I'm stuck yet again LOL!!!

  5. #5
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    How about you create a brand new textbox next to your Priority one and stick the iif statement healdem suggested in it?
    George
    Home | Blog

Posting Permissions

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