DateDiff result to table field

[tbjmobile@gmail.com]

New to Access 2016 and the forum.
Hi Everyone, I've switched from Aplha 5 to Access and I need to display as a field in the table entry the difference between 2 dates (arrive and depart). Alpha 5 has a similar version of VB and can display the result in the table fileds called Nights.
I could do this easily before but it doesn't seem so easy in Access. I've tried the DateDiff function but I can't work out how to just have it calculate AND display it in the table so that the operator can choose how many times the apartment is cleaned during a holiday. Once per week is standard so doesn't need any calculation but if a holiday goes over 9 days but isn't 14, then an intermediate clean needs to be organised. Maybe it could be done by number of the two dates and simple maths?
Thanks for any help,
Trevor Johnson

[ranman256]

DateDiff IS the answer

in a query , calc:
DateDiff("d",StartDate,EndDate)
or
NextCleanDate: DateAdd("d",[NumDays],[LastCleanDate])

[tbjmobile@gmail.com]

Thank you, I was working on your suggestion and I thought of 'Int' as I looked through the functions list. Int([Depart]-[Arrive]) works and gives me the number of days between [arrive] and [depart]. Thank you for your prompt suggestions.
Trevor.