Search results

I was just wanting to group the records on the report only. The record itself will still have it's original date/time in the table. Here is a picture of how it worked on my first week of records. I will not show the Expr1 (Column1) results on the final report, and only show the real date...

Thanks, plog I added a new column to my query. Expr1: DateAdd("h",-4,[Date_Time]) In the report I use this field to group by. Solved, Again many thanks!!!

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...

Only shows employee's with night in their shift field

Here is how it is working: Between the time of 07:00:00 AM and 04:30:00 PM Only Employee's with Day listed in their shift field are shown. Between the time of 04:30:01 PM and 03:00:00 AM Only Employee's with Night listed in their shift field are shown. Between the time of 03:00:01 AM and...

Made a few adjustments and it works. Here is a snap shot. Thanks

Our Day shift is from 7:00 am till 16:30 Our Night Shift is from 16:31 till 3:00 the next day

Here is how the query looks ran. Day and night are distinguish in the shift field. Is there a way to tell access to look at the present time and only pick the day or night.

No Date/Time I use the table to set an employee name to number. The query is right now only used to show active employees. So right now we have 259 different names, but employee's still working for us that are active is 88.

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...

That worked, Thanks :):):):)

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...

Thank you, that worked!!!!

Can you give and example using between and DateAdd together.

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...

Here is my code: Private Sub Command_Coating_Click() If IsNull(Me.cboEmployee) Then Me.cboEmployee.SetFocus MsgBox "Employee Cannot be blank" Exit Sub End If If IsNull(Me.cboMaterial) Then Me.cboMaterial.SetFocus MsgBox "Material Cannot be blank" Exit Sub End If If IsNull(Me.cboLength)...

Thanks Stumac that worked. gemma-the-husky. I'm not adding the same details to two tables. The records are going to one table called inventory. Then I'm running a query with sum function to get the balance of each item in stock. So as the guys pack barrels into boxes that is inventory so...

How to make it where they have to have data in the field. I added this to the top of the code. If IsNull(Me.Text64) Then MsgBox "Quantity cannot be left Blank" Cancel = True Me.Text64.SetFocus End If It gives me the message block, then I hit ok it closes the form and saves the record with a...

Worked exactly right. Thanks, problem solved

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...