select date in SQL

  • 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..
 
If you use the Query Grid, enter in the criteria row for the Date Field /
Column

BETWEEN [StartDate] AND [EndDate]

When you run the Query, Access will ask you for the [StartDate] and
[EndDate]

Check Access Help / Access books on Parameter Query.

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