we even tried out with that but the problem is that the year variable we are not able to get the accurate value like 2.5yrs ..instead we get 3 yrs ...so any soulution for that

Try the YEARFRAC function ( See Access Help )

YEARFRAC

Calculates the fraction of the year represented by the number of whole days between two dates.

If this function returns the #NAME? error value, you may need to install msowcf.dll.

Syntax

YEARFRAC(start_date,end_date,basis)

Start_date is a date that represents the first (or start) date.

End_date is a date that represents the last (or end) date.

Basis is a number from 0 through 4 that specifies the type of day count basis to use.