Search results

How can I change the start time of a day to 04:00:00 AM and end on the next day at 03:59:59 AM. I am getting the records from a query that includes all records from a week. I want to group all records on a single day. For example records from: Friday 2-2-2023 04:00:00 AM till Saturday...

Need help with setting a criteria in a query. Table is called Employee. I use this query to select your name from a combo box on a form. I am wanting it to only show the names of employee's on day shift during those hours and night shift during their hours. I have A field named "Shift" it...

I am wanting to pull all records with the criteria for the Day field to show all records from yesterday at 7:00 am till today at 3:00 am. Day field is a date/time format, Table name is Barrel Production . Here is what I have tried with no luck: Between date()-1, 07:00:00 and date ()+1...

I am wanting to run a query that shows all the records between two different dates but between hours. A work day starts at 7:30am and ends at 3:00am the next day. I have a form that I enter the date into that feeds the query. The table field name is day and it is in the date/time format...

I’m new to this so please be kind. I am creating a simple inventory db. I have a form that we enter into the table inventory. Right now we enter in everything once as inventory, then again to out to coating or ship to customer. I’m looking for the code to create a button enter the record...