Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Mar 2012
    Posts
    58
    Thanks
    11
    Thanked 0 Times in 0 Posts

    Iif statement in access query with color criteria

    Hi

    I am trying to alter the following IIF Statement:

    IIF(IsNull([Diff],"",IIF([Diff]>0, "Over","Not Over"))

    This is working correctly but I was wondering if there was a way to add in a light gray highlight when the conditional is "Over"? This IIF statement is in an Access query. Ideally I would like the entire row to highlight where the condition is "Over".

    J

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,513
    Thanks
    3
    Thanked 46 Times in 46 Posts
    Unfortunately there isn't a way of doing that in a query. However, with conditional formatting, you can display the results of a query on a form or report. See Using Conditional Formatting in Access 2010 Reports for details on how to do it for reports. This Change the appearance of a control... is a bit less technical look at both forms and reports.
    Wendell

Posting Permissions

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