There are many ways to do that anyway you may try with a DATE BETWEEN like
<b>SELECT * WHERE MYDTFIELD BETWEEN #01/01/2009# AND #02/01/2009#</b>
Another way to improve performance is to add an index or multiple indexes. If you often use multiple fields in your query, create an index that groups those fields together.
You create an index by using the index button on the table design view.