use SQL in Access with date range selection

G

Grey

How to use SQL in Access to select records with "date between"? I have datetime field in a table and i need to search records from this table. But I don't know how to use the date between to specific the date range in the selection.

Million Thanks..
 
V

Van T. Dinh

Already answered in newsgroup "microsoft.public.access.forms"

Please do not multipost and use Plain Text rather than HTML.

Please see http://www.mvps.org/access/netiquette.htm

--
HTH
Van T. Dinh
MVP (Access)



How to use SQL in Access to select records with "date between"? I have
datetime field in a table and i need to search records from this table. But
I don't know how to use the date between to specific the date range in the
selection.

Million Thanks..
 
Top