Selecting a Date Range

P

PegGall

I am running an append query and would like to be able to have it ask me for
my date ranges ie. Between #??# and #??#. Not exactly sure how to do this.
 
F

fredg

I am running an append query and would like to be able to have it ask me for
my date ranges ie. Between #??# and #??#. Not exactly sure how to do this.
Click to expand...

Where YourTable.[DateField] Between [Start Date] and [End Date]
 
O

Ofer

Try this

Select * From MyTable Where MyDateField Between [Enter Start Date:] and
[Enter End Date:]
 
Top