Search results

Good Morning ! I would like to using my .acce file more then 5 computers. What's the good ways to use this file? This app have 5 users, like - Admin - HR Manager - HR Supervisor - Recruitment Supervisor - HR Secretary

Sorry for late response. Ramadhan Kareem to all. I uploaded db with "tblPayrollData" table. I need latest records is taken next appending. Now there have 33 records available. When I tried to appending NEW record that is taken FIRST 33 records. Not token latest records.

Thanks for your response. No, I dont need filter, it is already done. I required, APPENDED query. When i run append query then it is taken Firstly recorded Year and Month DATA what is I disliked. Thinking an example : Present data is already there DEC/2022 & JAN/2023 in table...

Thanks for your response. I show the employee record editor form for understood records appended FIRST rows only. Post # 18 attached database is worked perfectly. But problem is the taken records FIRST row only where I would like to taken latest update records each time appended. For that I...

Thanks for you reply. You can see the table and data in the post #18, I want to know, where do i mistake that appended query take first rows data only, Not taken latest updated data from the table "tblPayrolldata".

Please check the post #18 My Ideas is MAX formula can work. But no sense which column is perfect to work. I would like to taken latest records from table "tblPayRollData" .

Hello Mr. @arnelgp . Hope, You are doing well I having a problem with the data that Its always appended previous 2 months ago records. In January I thought it was my mistake. February I do it carefully. see picture. my questions, why everytime 2 months previous records have been taken ?

I have a form where have textbox "[Incident Count]". if incident Count = 0 then GREEN and if it is increasing then colur will be increase then if incident count = 10 then RED if tried to conditional format. [Incident Count] > 0 And [Incident Count] <= 10 It is worked. as GREEN and RED I want...

I am sorry for delay response. We are off-day FRI & SAT day. Private Sub btnAverageMonths_Click() Dim db As DAO.Database Dim rs As DAO.Recordset Dim strSQL As String Dim dtExpired As Date Dim dtNewExpired As Date Dim intMonth As Integer Dim intCount As Integer Dim intAvg As Integer Set db =...

Hello, it solve by ChatGPT . Now average quantity 40 - 77 pc's

Sorry not like that, You make it a column result with Average Quantity. But you see the Employee Quantity is same as before. now your calculation average 53 Quantity each month. Our conditions is PresentDate (any ExpiredDateEn) to Add anyone (3 or 6 or 9 or 12) months for the...

This is missing month is MAR - MAY - JULY - SEPTEMBER - NOVEMBER. and there not same quantity every months. I need every months average same quantity divide by total Employees. Note : if its 1 or 2 pcs quantity (- / +) no problem.

Okay. I added the field of MONTH. How to make average every month same quantity ?

English is not my tongue languages. I knew, I am not fluent English You don't understood post 20 because you're not read previous posted. read Post 10 & 14. Sorry, I can't write ARABIC. just read 55 % only..

That is my question, How can giving result 58 -/+ With calculate from ExpireDateEn field (present date) to ADDED (3M OR 6M OR 9M OR 12M) equal all employees. don't count any year overlap. because we have present date and renew from this date.

No sense that why you don't understood, If you are looking POST # 10 and # 14. There clear presentation what I would like to do. About renew : There I saying that YOU CAN RENEW 3m Or 6m Or 9m Or 12m. You can't renew : 1m or 2m or 4m or 5m or 7m or 8m or 10m or 11m renew. AND ExpireDateEN =...

Thanks for your response. We can, But problem is money crisis. If it is average every month equal same quantity then we maybe do it.

Look the tblEmployee - ExpiredDateEn field date is PRESENT DATE. Now need to renew for example JANUARY Or FEBRUARY 2023. Open QUERY "Count_By_Month", you can see the MONTHLY quantity available If you looks MARCH 2023 is 200 Quantity. If you looks SEPTEMBER 2023 is 9 quantity only. So, I need...

First all, it not contract Expire Date. It was RESIDENT CARD expiry date. Government method by renew within 3/6/9/12 M I tried to showed that If I will RENEW 3/6/9/12 M then what is date exactly became the Expiry Date. You can see there have a CURRENTDATE what have the present date. And We...

I am sorry for delay response. This is the sample data. By Month Here Renew Method