To calculate for employee work experieance

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.

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.
Mary

"yyyy" for year
"m" for month
You'll have to do a check because DateDiff rounds off.

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

you could try it with a query...on column with start date, one with end. third that calculates...

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

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?