I tried this:
DaysSpentHere: DateDiff("d",[Date of Arrival],[Date of Departure])
but it is not exactly what I am looking for.
When I put the "DaysSpentHere: DateDiff("d",[Date of Arrival],[Date of Departure])" in, the query in makes me enter the Date of Departure in a parmeter everytime I open...