Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Thanked 0 Times in 0 Posts

    Minimum Date (2003)

    I have a field called Effective from date that has history. I would like to get the minimum Effective from date for Unique Record Id. A record Id could have the following effective from date 1/1/09, 1/1/08, 1/1/07. I would like to get the minimum effective from date for the Unique Record Id. What syntax would I use in a query?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Minimum Date (2003)

    Create a query in design view based on your table.
    Add the Unique Record ID and Effective From Date fields.
    Select View | Totals or click the Totals button on the toolbar.
    Set the Total option for Effective From Date to Min (that for Unique Record ID can remain the default Group By).
    Switch to datasheet view to see the result.

Posting Permissions

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