query with Enter date

  • Thread starter Thread starter Tbyird
  • Start date Start date
I like to use something like this:
=datevalue([Start Date]) and <(datevalue([End Date])+ 1)
Mark
-----Original Message-----
I want to set up a query where I have to enter the date
each time in the following columns.
7/1/04
Click to expand...
Between x and y dates... how do I put this in the criteria?
.
Click to expand...
 
I'm just getting familiar with Access, how about a parameter query -
Between [Enter Start Date] And [Enter End Date] You will be promped for the
dates in question.

Bruce Girvitz
 
Back
Top