You didn't indicate whether the "date input field" is populated with strictly
a date value, or whether it also contains time information (as with the NOW(
) function).
If the field only contains date information, you should be able to write a
query that looks something like:
SELECT *
FROM yourTable
WHERE [DateField] Between #4/2/2007# and #4/6/2007#
If the field contains time data, you will need to modify the query a little
because the above query would not capture date field entries that fall at
noon on April 6th. To get those values, you would need to either convert the
[DateField] to a date using the DateValue( ) function:
WHERE DateValue([DateField]) BETWEEN .....
or you could change the the WHERE clause to:
WHERE [DateField] >= #4/2/2007# and [DateField] < #4/7/2007#
If you are doing this via a parameter query, the first example would look
something like:
PARAMETERS [StartDate] DateTime, [EndDate] DateTime;
SELECT *
FROM yourTable
WHERE [DateField] Between [StartDate] and [EndDate]
HTH
Dale