[AccessD] Min Date in a query SOLVED!

    You are most welcome William!

Best wishes,
A.D. Tejpal
------------

  ----- Original Message ----- 
  From: William Hindman 
  To: Access Developers discussion and problem solving 
  Sent: Wednesday, April 01, 2009 19:59
  Subject: Re: [AccessD] Min Date in a query SOLVED!


  AD

  ...that works, THANK YOU! ...I KNEW there had to be a simple way to do this 
  :)
  ...and my sincere appreciation to all who tried to help me with this.

  William

  --------------------------------------------------
  From: "A.D.Tejpal" <adtp at airtelmail.in>
  Sent: Tuesday, March 31, 2009 12:45 AM
  To: "Access Developers discussion and problem solving" 
  <accessd at databaseadvisors.com>
  Subject: Re: [AccessD] Min Date in a query

  > William,
  >
  >    Sample query given below, gets the first record in table T_A where the 
  > value of date field EDate is greater than Date().
  >
  > ==================================
  > SELECT T_A.*
  > FROM T_A
  > WHERE (((T_A.EDate) In (SELECT TOP 1 EDate FROM T_A  WHERE EDate > Date() 
  > ORDER BY EDate)));
  > ==================================
  >
  > Best wishes,
  > A.D. Tejpal
  > ------------