Query in MS Access

[AHHNPANTH]

Please tell me anybody how to create query for formula of date difference. I need it urgently to calculate to find out net service of employees in MS Access.

Regards

[Pratul_09]

There is a DATEDIFF ( DatePart , StartDate , EndDate ) and DATEADD ( datepart , number, date ). The query will be
SELECT DATEDIFF ( DatePart , StartDate , EndDate ) AS datenew where clause.