Recent content by Unicon

Dear all Greetings, Just a small question. I have a database (Access 2003 and I am using it with Access 2007 with user level security) on shared folder on internal Dell server and I have created a shortcut to each user's machine to access it. This days I am facing a problem of db size as every...

Hi Pat, Thanks a lot for your advise. I have created tables for the same (attached) but no idea how to start with. Please advise. Looking for your help as always.

Dear all Greetings, We have our own accommodation for our employees and each room we have 3 bed spaces like Room G01 = 3 bed spaces Room G02 = 3 bed spaces We are assigning employees to each room and currently using simple excel spreadsheet to assign employee but most of the time we are...

Dear all Greetings, I have an employee table with employeeID and site defined (DB attached). I have another table “attendance”. I just want to feed attendance with concerned employeeID with their pre defined site and if I entered attendance for concerned employeeID with wrong site (different...

Thanks pr2-eugin it work fine :)

Dear all, I have a query with field of [DateofJoining] I want to create another field and want to see the value that what date will come after 22 months for that [DateofJoining] field. Please advice.

Hi all, I am trying to use Dsum criteria with multiple values but it's not working for me. Please see below I am trying to sum up 4 state's total but its not working for me. =DSum("[S/G(M)]","QryCurrentRequirements(ClientHeads)","[State]=2 Or 4 Or 6 Or 7") Please advice.

Thank jzwp, I will look after and follow the attachment let’s see how it’s turn out. Once again thanks for all your support provided.

Thanks again jzwp, Yes rates and hours associated with each emirate will not change over time. I didn't find qryMostCurrentSalaryDate and qryCurrentSalary in attached DB. Please advice.

Hi jzwp, Please see my comments below, This is confusing, can we separate the DXB from others? Yes we can separate. The DXB basic salary is 570 according to your spreadsheet. So to get this they must work how many hours a day for how many days? It looks like 9 hours a day for 26 days. Is...

In addition to that as per the contract which we are providing them is DXB salary total 1000, and the moment they go to other emirates they will get 2000 concept salary and once they come back again to DXB than they are eligible for 1000 salary. And one more thing I need to show salary breakdown...

Hi jzwp, For DXB staffs and the staffs who are earning BasicSalary more than 2000, they need to work 9 hours for 26 days and for other Emirates they need to work 9 hours for 30 days. That is the entire concept. Yes it’s determined by what Emirates the person works but the challenge is some of...

Thanks a lot Jzwp, I have updated salary part (QrySalaryCalculation) with the new tables but unable to update Rates and hours into my query. Honestly speaking I don't know how to get it in query. Please advise me regarding the same so that I can start update my database. Please advice.

Thanks Jzwp, I have attached a spreadsheet for your review. Please have a look on it. We are currently processing in the way attahced in spreadsheet. Waiting for your feedback.

In addition to that I have attached db again as there is a problem with criteria which you have provided to me. Just have a look on Query3 where ID no. 100338 worked for 26 days in DXB and 5 days Training in AD but the criteria is showing 26 NormalDays for both where it has to be 26 Days Normal...