>>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.