Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2013
    Posts
    6

    Unanswered: Query to find max date in row from multiple columns

    I have six columns a table called WIN. The columns I have are:

    Assigned Date
    Submitted
    Revisions 1
    Revisions 2
    Follow Up
    Completed

    I want to run a query that will return the max date entered for each row within these columns. How do I go about this?

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Allen Browne has a hack for this type of thing:

    Microsoft Access tips: MaxOfList() and MinOfList() functions

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    Join Date
    Jul 2013
    Posts
    6
    Works perfectly. Thanks!

  4. #4
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    You can usually depend on Allen's hacks!

    Glad we could help!

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

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