Date Criteria to seach in access

[missippi]

I wanted to change my current query to a dynamic one. I am looking for a renewal date between date that I would like to user of the program to pick
This works but isnt dynamic:

Between #10/1/2002# And #10/31/2002#

This is what I tryed but it doent work. It does ask for the start date and end date though.

Between "Start Date"=[Start date example 2/1/2003] And "End Date"=[End date example 2/28/2003]

 

[ETID]

how about...


>=[start date] and <=[end date]

 

[Nikita6003]

Or

 Between #[Start date example 2/1/2003]# And #[End date example 2/28/2003]#

Cheers
Nikki