Filtering Access Reports

[poteatc]

I want to filter my reports according date and time. I am already successful with filtering dates and times, but not overnight. I want to filter according to a shift that starts for example, 10/19/2008 Date From
10/20/2008 Date To

17:00 Start Time
7:00 End Time
(How do I get all of the results in between ?)

The results come back blank according to this criteria, but I can do it for the same day. This is very confusing.

[emsik1001]

Hi

Do you have date and time as separate fields?

This is tricky one... in the past what I did I joined date + time converted to number and then said what range I want :) but I'm sure there is a better way of doing that.

Regards
Emil

[NeoPa]

From the question, the answer is simply that you use "Between A And B".

I somehow doubt it's as simple as that though. Please try to explain more clearly including all relevant information. Are your values stored separately with dates in one variable and times in another? How are they held in your records - as separate dates and times?