use SQL in Access with date range selection

  • Thread starter Thread starter Grey
  • Start date Start date
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..
 
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..
 
Back
Top