By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,441 Members | 996 Online
Bytes IT Community
+ Ask a Question
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
Share this Question
Share on Google+
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

MMcCarthy
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
  1. DateDiff("m", [Begin date], [End date])
Mary
Mar 12 '07 #3

Rabbit
Expert Mod 10K+
P: 12,365
Expand|Select|Wrap|Line Numbers
  1. 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

MMcCarthy
Expert Mod 10K+
P: 14,534
Expand|Select|Wrap|Line Numbers
  1. 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

MMcCarthy
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
  1. SELECT empID, Sum(DateDiff("d", [Begin date], [End date]))
  2. FROM Employees
  3. GROUP BY empID;
  4.  
Mar 13 '07 #8

Post your reply

Sign in to post your reply or Sign up for a free account.