select date in SQL

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

 

[Van T. Dinh]

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