Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Location
    Indiana, USA
    Posts
    79

    Unanswered: Compare Cells and Display Most Recent Date

    Hi All,

    Since the search is not working properly, I can't check if this has been answered before.

    I have a report called RptSkilled_Services

    Three Textboxes - PTend, OTend, and STend. These are dates that the services ended.

    On the Report, I need to have those three dates compared and the most recent date appear in the control.

    example

    PTend - Jan 1 2000
    OTend - Jan 5 2000
    STend - Jan 10 2000

    The control would display Jan 10 2000.

    Please help! It's making me crazy
    Perplexed
    Eat a toad every morning and nothing worse will happen to you the rest of the day!

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    You could use a nested iif() statement to do this.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Feb 2004
    Location
    Indiana, USA
    Posts
    79

    Compare

    Hadn't thought of that.

    I have used If Not IsNull to hide/show contols based on whether another textbox had data or not. .... I'll give it a try.

    --- I'm back
    Works like a charm. Easy when you know.
    Thanks for giving me a chance to work it out for myself.
    Perplexed
    Eat a toad every morning and nothing worse will happen to you the rest of the day!

Posting Permissions

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