How do I query a table by dates?

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
Back
Top