How do I query a table by dates?

D

DDrowe

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

Thanks

David
 
B

bin_leigh

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#

Enjoy.
 
Top