date query

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.
 
V

Van T. Dinh

SELECT T.*
FROM YourTable As T
WHERE T.RecordDate BETWEEN #06/10/2004# AND #06/15/2004#

HTH
Van T. Dinh
MVP (Access)
 
Top