query with Enter date

T

Tbyird

I want to set up a query where I have to enter the date
each time in the following columns.
Between x and y dates... how do I put this in the criteria?
 
M

Mark

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.
Between x and y dates... how do I put this in the criteria?
.
 
B

Bruce Girvitz

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
 
Top