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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Start Date/ End Date query 7
Combine Duplicates in Query 0
Multiple Criteria's 1
Between . . .And problem 1
Transpose rows to columns in Access. 3
show balance in a query 1
display records from a query 1
Calculating difference based on prior entry in same table 1

Back
Top