I have a table with fields that include date1 and time1 which hold a date (mm/dd/yy format) and time (short time.) I'm trying to use a query to bring up records for a date that the user selects that have a time between 7pm on the date the user selects and and 2:59am on the date that follows (an 8 hour period.) I've not been able to figure this out.