I need to make a query for a report that will only show the new records added during a certain 24 hour time frame. The time frame which i had in mind was from 7:00AM yesterday-7:00AM today. Right now I have it set on today's date as a criteria, but everyday we need to print 2 reports rather than just the one, plus there are many records which aren't supposed to be in the report which can cause confusion.
If it helps the 24 hour time frame can also be seen as a 3 shift day. The shift number is also a field in my query. Shift 1 starts at 7:00AM yesterday; shift 2 at 4:00PM yesterday; and shift runs from 12:00AM today - 7:00AM today. The report I would like to print everyday would have all records entered in these 3 shifts. So there may be a way to set a shift specific criteria rather than a date specific criteria.
If it helps the 24 hour time frame can also be seen as a 3 shift day. The shift number is also a field in my query. Shift 1 starts at 7:00AM yesterday; shift 2 at 4:00PM yesterday; and shift runs from 12:00AM today - 7:00AM today. The report I would like to print everyday would have all records entered in these 3 shifts. So there may be a way to set a shift specific criteria rather than a date specific criteria.
