number according to days a booking 22/02/08-19/02/08 =3

  • Thread starter Thread starter Christa
  • Start date Start date
C

Christa

i want a cell to automatically calculate how many nights a guest slept in a
room.
I have a check in cell and a check out cell as well as a days spent cell.
what is the formula I have to enter? and what do I have to do?
 
Do not create a field for this in your Access table.
Rather, do it in a query. That way it cannot go wrong.

Assuming you have fields named StartDate and EndDate, you would type this
into the Field row in query design:
Days: DateDiff("d", [StartDate], [EndDate])

More info in this article:
Calculated fields
at:
http://allenbrowne.com/casu-14.html
 
Back
Top