Selecting a Date Range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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]
 
Try this

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