Search results

Hi jzwp22, Any updates? Please advice.

Hi jzwp22, I have tried to calculate NormalDays and OverTime in my payroll in many ways but wasn't work for me. I just want to calculate in a way as attached. Please have a look on it and advice. I just want to caculate NormalDays and OverTime like that way (Employee need to work 26 days to earn...

Thanks jzwp22 for all your support, hats off to you guys who are always helping people like me. I will just go through your advise. I will again disturb you ;) If I hit a snag in between. Be ready for some more question :D. Once again thanks a lot.

Thanks jzwp22, I understand that all the field is being calculated correctly but all those calculation is calculated based on 26 days criteria in that query if someone work for 26 days he is eligible to get 1000 and if more than it will be consider as Overtime but the problem is when some one...

Thanks again jzwp22, I have included same criteria but still it is not working. Yes employees are entitled to be paid for public holidays as well and sometimes they worked for 26 days as N and 1 as PH where my criteria will calculate it easily but some cases some employee will work only 26 days...

And one more question I have pasted those code in my query but it's showing that 500 advance for all employees in query which supposed to show for ID no. 100001 only.

Thanks a lot jzwp22, I want to let you know that sometimes staff will work for 26 days only where sometimes month will come with 1 Public Holiday (PH) and in this case some staff will work like 25 days as N and 1 day as PH and in this case we need to pay them 26 days as N and 1 day as PH...

Dear all I am a learner with access database. Please find attached database. Things are working fine and I am still developing it but in between I got a problems as below. •If someone work 25 Days as code N means normal days and 1 day as PH means public holiday and it supposed to be a NormalDays...

Thanks pbaldy it's working now. I change the name of subform. :)

Please see the attachment. I again put textbox name GTotal but still its not working.

I have a calculated subform in form where in subform in the footer area I put =Sum([GrandTotal]) and its giving me an exact value of -39 after the calculation. I want to show it in form I put correct formula to show that value in form but its showing error. I put...

Dear all, I am developing KPI for my office (please see the attachment). How can I get score and result in sheet. I have around 1200 staffs. Please advice.:confused:

Dear All, Please see the attachment. I want to get a Sum of Duration (mean total hours for that particular date), I simply put Sum in Total field of query but it's showing some error. Please advice.:confused:

Hi all, I open my 2003 database from access 2007 and try to see the forms which was alreday designed in 2003 but i can't see it. Later on again I open same database from 2003 and found that my whole forms deleted automatically from the database. No idea how this happen. I tried to open it in...

Dear all, I have a database in access 2003, now we move to office 2010. Can I still use that 2003 database in access 2010?? If yes than how to use?? or I have to forget about my 2003 database? Please advice.

Dear all, Please see the attachment. I want to get a NormalDays from ANormalDays. I want to make 26 days in NormalDays If ANormalDays is 26 or 27. I put a condition like that but showing that Query is too complex. :confused: Please advice.

Thanks Bob, This is working :)

Daer all, How do I use Round Function in query? As I put below function in my query but its showing (53.5384) Which I want to show 54 only. NonDeployedDaysEarned: Round([BasicAsPerState]+[StateFoodAllowance])/26*[NonDeployedDays] Please advice.

Hi Bob Thanks a lot, My whole concern is if someone works less than 26 days than I need to get those days from SickDays you can say NormalDays = 25 SickDays = 4 I want to take only 1 day from that SickDays which will make 26 days. I want query to show that value 1 day. NormalDays = 23...

I have a query where I have a field NormalDays and SickDays. I want to calculate if someone has Less than 26 days than it will take rest days from SickDays like below NormalDays = 24 SickDays = 4 I put function like IIF([NormalDays]<26,[NormalDays]+[SickDays],[NormalDays]) But in...