date query

  • Thread starter Thread starter Rick Oakley
  • Start date Start date
R

Rick Oakley

How do you run a query that will pull up all the info for
a length of time using dates. Example.

I want all the records entered from 6/10/04 thru 6/15/04
and all records inbetween.
 
SELECT T.*
FROM YourTable As T
WHERE T.RecordDate BETWEEN #06/10/2004# AND #06/15/2004#

HTH
Van T. Dinh
MVP (Access)
 
Back
Top