Trying to create a field in Access that calculates time off.?

Hi. To solve this question you have two or more options but the easy way is creating a query and type the following function:

Weeks_Off:DATEDIFF("M";[DT_INI];[DT_END])

Datediff function will bring the difference between two dates the way you want (you can use weeks, days, years, etc), it´s only a matter of typing the initial character of the criteria (w for week, m for month, y for year, d for day, etc).

In this case, it will show you the difference in months, the information you need to show.

Hope it helps.

Obs.: it´s only a matter of creating a query and copy and paste the formula/function I've type above. You'll need add the other fields so you'll have the complete set of information (name, dates, etc.)