Access Time Filter

[djohnson09]

Hello,

I have a form with various fields in it. 2 of the fields are Time (user input) and Date (default to current date, user can change). I need a filter that will start at 10:00 PM on the previous day and show only the items through 9:59 PM of the current day, then start over again.

For example, if it is 7/25, I want everything that has been keyed in from 7/24 - 10:00 PM through 7/25 - 9:59 PM

Thank you.

[tanvi]

Welcome to the forum. You can check this article which has step by step information on how to Filter, sort, and group data on date and time values: http://office.microsoft.com/en-us/ac...001054662.aspx