Search results for query: *

Thank much combo. That's all what I expect to solve my data first. SELECT TempImportExcel.EmployeeID, TempImportExcel.WorkDate, TempImportExcel.Time, (SELECT Count(*) FROM TempImportExcel As X WHERE X.EmployeeID = TempImportExcel.EmployeeID And...

Maybe my English is not so good for the explanation. As I said before, the machine do not need parameter to indicate what is IN what is OUT, It just bases on EmployeeCode (no need to set the Shift) and how many time he puts the finger into the machine to take fingerprint. He puts 1 time (the 1st...

Regard to put IN/OUT in the time sheet list, I just want to imitate what the fingerprint machine does. The machine has 3 options for setting to record employees in and out. 1. Record base on switching IN/OUT on menu of machine. Employees have to chose IN or OUT before fingerprint. 2. Record base...

Please try to help me this issue. Thank you very much.

You try this. Add "Me.Undo" after the line Cancel=True.

Yes, we have. 1st Shift: 6:30 - 14:30 2nd Shift: 14:00 - 22:00 3rd Shift: 22:00 - 6:00 Sometimes there's a case that Employee went home and forgot to fingerprint [OUT] so machine has just record 1 time of fingerprint for that employee. Record 1 time is [IN]. The case 2nd shift works until 0:15...

Thank Andrzejek and SkipVought for your reply. We cannot assume that AM is [IN] and PM is [OUT]. Ex: There's a 2nd Shift from 14:30 - 22:00 -> 14:30 is [IN] and 22:00 is [OUT] So I cannot use Update query as Andrzejek suggested because cannot define what time is IN or OUT. The arithmetic of...

Dear All, I have a list of Employee time sheet from Fingerprint time attendance machine. But the machine software have problem so the time In and Out was not displayed on the Field IO so I cannot know what time is In, what time is Out. The list as below. Could you help me to use Query or VBA...

Hi MajP, It works like a charm! Thank you very much for your help. Very fast response! I really appreciate that.

Dear All, Please help me this task. - I have a Production plan for product A, B, C.... - Each product has a production time. Ex: Product_A: need 100 hours to finish all required Quantity. - I have 3 shifts per day. Total producing time per shift: Shift 1 - 126 hours; Shift 2 - 119 hours; Shift...

Thanks MajP. The SQL is so powerful. I thought we have to write some code to get this result but not, pure SQL also enough to do this. I follow you and complete the Union query for my case as below: ................... SELECT tblLoanAmount.LoanAmount, tblLoanRates.RateStartRange...

Thanks much MajP. This work great as my expectation. Your graphic make it easy to understand.[thumbsup]

thread705-1624516 Hi all, I am from Vietnam so my English is not so good. Please understand me if having something not clear in my express below. I needs help from you about calculate the bank interest and days as in the thread705-1624516 (from 2010). Sorry to dig it again because it correct...