I was trying that kind of thing but MySQL doesn't seem to like it. The SQL
statement does have the [Start Date] in the statement instead of ?. I am
sure this worked fine on an Access database I worked on before but it might
be the change in database that makes it not work now. I'll keep hunting.

Thanks for responding.

"Shane Devenshire" wrote:

Hi,

This works for me on the Criteria row in MS Query:

=[Start Date] And <=[End Date]
as does this
Between [Start Date] And [End Date]

Try looking at the SQL statement in MS Query - in my case it is

WHERE (Employees.HireDate Between ? And ?)



--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"rasinc" wrote:

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