Hi, I am trying to run a report for the actions took place within last 24 hours starting from 6am yesterday to 6am current date. There are 3 shifts in a day 6am - 2pm, 2pm - 10pm and 10pm - 6am.

I am trying to capture the transactions took place during these shifts. Report will run 7:30 but it should only capture the data between 6am to 6am.

The table has transactiondate and tansactiontime fields. I know these could easily be merged into one field trough a formula.

Any help would be really appreciated.

Thank you DBlank. This will work! Thank you for all the help.