asking user for dates

[Haroon]

hi

i want to create a query which asks user for start date and end date
the start date is like 1st apr 2009
and end date is like 30 apr 2009

what shall i put in the criteria box?
i have [enter start date] for the start date column
and [enter end date] for the end date column

it dont work

anyone know to show this

thanks in advance.

 

[Tom van Stiphout]

On Thu, 2 Apr 2009 03:15:02 -0700, Haroon

That is indeed how this is done. And you set the parameters to be of
datetime type. Here is an example from Northwind:
PARAMETERS [Give start date:] DateTime, [Give end date:] DateTime;
SELECT Orders.*
FROM Orders
WHERE (((Orders.[Order Date]) Between [Give start date:] And [Give end
date:]));

-Tom.
Microsoft Access MVP