Im having some trouble trying to figure out how to make a report run based on a date and time range.
What I have is a Form with 4 text boxes and a print report button. What I want to do is enter in a date and time range and then run a report based on that information. So I have Two text boxes that are start date and end date and two that are start time and end time. I have a query Criteria set to look at the form and the boxes problem is that I can not get it to look at all 4 boxes its only 2 or 2 any way i can get it to look at all 4?
Appreciate the help on this.
Here is the code I have so far in the query criteria
Expand|Select|Wrap|Line Numbers
- Between [Forms]![DateReport]![StartDate]And[Forms]![DateReport]![EndDate]'this works
- 'have tried variations but no luck so far
- Between [Forms]![DateReport]![StartDate]And[Forms]![DateReport]![StartTime]And [Forms]![DateReport]![EndDate]And[Forms]![DateReport]![EndTime]
- Between [Forms]![DateReport]![StartDate]And[Forms]![DateReport]![StartTime]And Between [Forms]![DateReport]![EndDate]And[Forms]![DateReport]![EndTime]