432,441 Members | 996 Online
Need help? Post your question and get tips & solutions from a community of 432,441 IT Pros & Developers. It's quick & easy.

# To calculate for employee work experieance

 P: 38 Alem: hi friends I tried many methods but it will increase or decrease three or four months. Please help me to get exact year and month . thanks in advance. Mar 12 '07 #1
7 Replies

 P: 38 Hi Alem: To calculate Employee work expereance in Ms-Access what shall I do b/c I tried by the following formulas but I got three or four month difference I can't get exact service year and that will display also with decimal number. which is meaning less. Service year: ((([diff])/30)/12) a person emplyed in different organization, fist I calcualte Begin and End date of emploment date then I use the above formula. Diff represents Begin date-End date Please help me what shall I do Thanks in advance. Mar 12 '07 #2

 Expert Mod 10K+ P: 14,534 Hi Alem Not sure what it is exactly you are looking for but the following will give you the number of months that employee was on work experience. Expand|Select|Wrap|Line Numbers DateDiff("m", [Begin date], [End date]) Mary Mar 12 '07 #3

 Expert Mod 10K+ P: 12,365 Expand|Select|Wrap|Line Numbers DateDiff("interval", Start Date, End Date) "yyyy" for year "m" for month You'll have to do a check because DateDiff rounds off. Mar 12 '07 #4

 Expert Mod 10K+ P: 14,534 Expand|Select|Wrap|Line Numbers DateDiff("interval", Start Date, End Date) "yyyy" for year "m" for month You'll have to do a check because DateDiff rounds off. Alem Please don't double post. I am merging this with your other thread here. Mary Mar 12 '07 #5

 100+ P: 110 you could try it with a query...on column with start date, one with end. third that calculates... Mar 12 '07 #6

 P: 38 Dear all (alem) I have got Your answere thanks a lot but my problem is not soved yet. let me explain again an employee employeed more than 3 organization Example in A company from 2/4/2004 to 3/8/2005 in B company from 5/10/2005 to 5/8/2006 in C company from10/11/2006 to now() To calculate service year for the above employee I used Service year: DateDiff("d",[MinOfBeginDate],(Now())) Year: ((([Service year])/30)/12) 30 represents months 12 represents year It displays number like 3.4897373 this that is difficalt to interpret Mar 13 '07 #7

 Expert Mod 10K+ P: 14,534 Alem, you clicked report instead of reply on your last post. I am including content below for others to see. Please be more careful. Assuming a table Employees and a field empID then you could use the following to get the number of days. How do you want that represented? Expand|Select|Wrap|Line Numbers SELECT empID, Sum(DateDiff("d", [Begin date], [End date])) FROM Employees GROUP BY empID;   Mar 13 '07 #8