Criteria For Date Range

S

steve goodrich

I have 2 date fields on my form

"date from" and "date to"

I have a parameter query setup so I can list by a date

Date From Date To

<=[enter date] >=[enter date]

Not sure how that works but it does (I enter the date when prompted in the
"date from" box and the query runs showing starting and ending dates for
every row.



How should I enter the criteria if I want to select a date range. E.g date
from 1/1/07 to 14/1/07



Many Thanks



Steve
 
S

sherwin verdun

depending on what you really need. if you wanted to have it sorted on date
from, enter this on the criteria of your query: between [enter date start]
and [enter date end], which will give you data from jan 1, 2007 to jan 14,
2007. you can also do that on the field date to, but it will have a different
result.
 
Top