How do I query a table by dates?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to be able to put in a date range for my querie. Is that possible.

Thanks

David
 
Yes... only need #around the date#

So before January 1, 2006 is <#01/01/2006#

A range is written on the same line... in the Design mode that would be:
#01/01/2000 and <#01/01/2006#
Click to expand...

Enjoy.
 
You must log in or register to reply here.

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

#error - Blank 3
how do i? 7
query based on date ? 1
query on date 1
Create a Query that Prompts for Date and Time 4
Combine Duplicates in Query 0
Count by short date and group by agent name 6
Dcount returning no results!!! 0

Back
Top