Hi,

I am trying to filter a range of dates. in a simple table I have created these fields: Client; StartDate; EndDate. and I am trying to filter the StartDate field, example from the 1st october to 31 of october 2008.

How can I accomplish this?

need help.

You want to filter, but WHERE ??? In the form, in the query, ....??

I think you want to do it in a query try the sql below


select
startdate,
enddate,
client
from clients
where
startdate between #10/01/2008# and #10/31/2008#

OK i want to filter in a form.

I will try your suggestion now.


Thanx a lot.

I suggest
to use FILTER BY FORM, CLEAR GRID, APPLY FILTER, REMOVE FILTER icons.