To filter records based on a date range I'm using the following criteria in a query:
Between [forms]![frmRptCriteria]![txtBeginDate] And [Forms]![frmRptCriteria]![txtEndDate]
However, if the date range is 1/1/07 to 1/31/07, the "Between" statement excludes any records created on 1/1/07 or 1/31/07, finding only those in between.
How can I remedy this? How should I modify the "Between" statement so that the query includes records that equal the begin & end dates plus everything in between?
(I tried "On Or Between..." but the query returned all records.)
Between [forms]![frmRptCriteria]![txtBeginDate] And [Forms]![frmRptCriteria]![txtEndDate]
However, if the date range is 1/1/07 to 1/31/07, the "Between" statement excludes any records created on 1/1/07 or 1/31/07, finding only those in between.
How can I remedy this? How should I modify the "Between" statement so that the query includes records that equal the begin & end dates plus everything in between?
(I tried "On Or Between..." but the query returned all records.)