>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#
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com