I am trying to get a query with parameters on a date field to show up properly.

#3/01/2009# And <#3/31/2009#

This above statement works in the date field criteria.

#3/01/2009# And <[Please enter an ending date]

This above statement does not.

Ultimately I want to set it up to do this

=[Please enter a start date] And <=[Please enter an ending date]

Is there any better way to do this or to make the above work properly?

Database is MySQL if it matters.

Any help is appreciated. rasinc