Need Between.. And to work with criteria from dialog box
I am putting together a report that will list calls received for a one week period. I created a dialog box so that the user can input the start date. In my query in the DATE field I tried to put the following criteria, but its not working.
Between [Forms]![frmWklyDialog]![StartDate] And [Forms]![frmWklyDialog]![StartDate]+7
I need it to pull records dated between whatever they enter in for the start date and the start date plus seven days.