Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Jan 2005
    Posts
    614
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Display for greater value (Access2003)

    I have
    InterviewLevel_____InterviewDate___LastStatusDate
    Phone_________________1/1/2008_____1/15/2008
    Personal_______________1/15/2008____1/15/2008

    I need to hide 1/15/2008 for InterviewLevel Phone because if interview took a second stage - this is where LastStatusDate should be displayed, not at Phone but at Personal.
    Data in Details.

    Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Display for greater value (Access2003)

    Is this in a query, a form, a report?

  3. #3
    5 Star Lounger
    Join Date
    Jan 2005
    Posts
    614
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Display for greater value (Access2003)

    This is a Report.
    Report displays result from the query.
    In reality yes - this date 1/15/2008 is valid as a StatusDate.
    However for the readability purposes it makes more sense to show last status only for tha last stage of the interview.

    Is the solution in changing a query?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Display for greater value (Access2003)

    You can use Format | Conditional Formatting to set the font color of laststatusdate to white if the interviewdate is less than laststatusdate.

Posting Permissions

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