>>>I want the date field in the Access 2000 Table to fall between
>>>the 2 dates, as selected by the user. But I hit error in the SQL
>>>Statement.
>>>
>>>... FDate >= '15/Aug/2000' AND FDate =< '18/Aug/2000'
>>>
>>>It prompts me that the "<" syntax error. Anything wrong? Thanks.
>>
>>Try this:
>>

FDate Between #2000/08/15# AND #2000/08/18#

>
>How to also include these 2 date. In other words, any date that falls
>on the 2 Dates 2000/08/15 and 2000/08/18 ? Thanks.

Between includes both of these 2 dates. Consider it like: date1 <= variable <= date2