Using "Between" with Calendar control

[rzkl]

I am trying to set up the criteria in a query to query a date/time range. I have a form with two calendars on it, a start date and an end date. Our work day starts at 4:00am and goes to 3:59 am the following day. I was trying to accomplish this by the following

Between [Forms]![frm_1ProductivityReports]![Calendar7]+0.16666 And [forms]![frm_1ProductivityReports]![Calendar7]+1.166665

That would be for the start date, Im not sure how to put the end date in. The end date portion would look like the line below. I cannot figure out how to join them together

Between [Forms]![frm_1ProductivityReports]![Calendar8]+0.16666 And [forms]![frm_1ProductivityReports]![Calendar8]+1.166665


Im still a novice at this so any help would be graet.

Thanks in advance

 

[vbaInet]

I'm not entirely sure what you're asking. Could you please elaborate.

If one calendar is for the start date why not put that as the first criteria in BETWEEN and refer to the second calendar in the second criteria of the BETWEEN statement?