I have a report that I have been using the DateAdd function to query the last 12 hours for a helpdesk log and that works no problem. Our shifts run from 7am to 7pm (days) and 7pm to 7am (nights). What I would like to do is make a query that would look at the time when generated and only grab log files that go back to 7am or pm. For instance, it's 12 noon and I try to print a log of the day shift so far, I want it to go and grab logs from 12 noon only back to 7am that day. I'm lost on how to start this. Do I need 2 constants (7am or 7pm) and then figure hours back to one of those times depending on when I run query? Or can this even be done......Help!