Search results

Thank u got the result!!

Hi Galoxiom, I tried that one.. Same output: eg: DOJ = 10-Jun-09 EXP = 3.0 I want the output as 2.7. Is there any other way to achieve that??

Hi, In my database I need to find the Experience of an employee based on his DOJ. So I have used a formula Round((((Year(Date) - Year([DOJ])) * 365 + (Month(Date) - Month([DOJ]) * 30.4 + Day(Date) - Day([DOJ])) / 365),1) in the control source property of my field Exp.and it worked well, i got...

Hi All, Thank u soo much!!! I hv read some articles regarding access table relationship and I modified it accordingly,and now my db is working in a desirable manner. Mr.B, Thank u soo much for ur correct guidance towards this.. THANKS EVERYONE!!!

Hi Mr.B, I am uploading my database for more clarity. Looking forward to ur reply, Thanks in advanvce!!

Select [staff info1].[sl no], [staff info1].[emp id], [staff info1].[emp fname], [staff info1].[emp lname], [staff info1].[emp photograph], [staff info1].[emp grade], [staff info1].[emp sex], [staff info1].[emp e-mail id], [staff info1].[saudi contact address], [staff info1].city, [staff...

Hi friends, I am developing a database for a small organisation. I linked 6 tables(basic info,educational info,employment info,passport info,leave info,personal info) in one tabbed form.For all the tables i have used emp id as the primary key.(for data entry). I have created a similar form...