Search results

Hi everyone, I have a table with employee names, time in, time out, and total hours. In a query I want to create an expression (i.e., Total Hours After Meal Break) that will deduct a 30 minute meal break from any day where the total hours column is greater than or equal to 6.5, but less than...

Hi everyone. I have a table hundreds of thousands of entries showing employees' name, store number worked at, date worked, timein, and timeout. I made a query which gives me the name, store number, date, timein, timeout, and hours by employee as follows: ID Name StoreNumber...

I have two Tables: 1. PaymentsTbl: has four fields--TruckerID, Name, PaymentDate, Payment Amount. 2. TruckersTbl: has two fields--Name, TruckerID I want to create a form that updates the PaymentsTbl. In other words, the form would have the same exact fields as the PaymentsTbl. The...

I have a table with a lot of transactions (date, time, name of employee, transaction number, etc.). There are two rows of importance to me--The date and time of the transaction. For example: Date--------------Time 1/4/2004----- 1/4/2004 9:05:00 AM 1/4/2004----- 1/4/2004...

Hello everyone, I am really new to Access and this forum has been TREMENDOUS help for me. I have unfortunately been unable to figure out how to do the following: I have a database that shows when an employee clocks in and out for work. In my database each set of clock in and clock out is on...