Calculating days from two different dates

[Fly Boy 5]

Expr1: IIf([Taken],[Date_To]-[Date_Fm]+1,0) This displays the days taken but
it would be nice to display days scheduled.

Date fields called Date_To and another Date_Fm for vacations. How can I
display days scheduled?

Thanks for your help!

 

[KARL DEWEY]

How can I display days scheduled?
You just gotta have fields to indicate the schedule - StartDate, NumOfDays.

 

[John W. Vinson]

Expr1: IIf([Taken],[Date_To]-[Date_Fm]+1,0) This displays the days taken but
it would be nice to display days scheduled.

Date fields called Date_To and another Date_Fm for vacations. How can I
display days scheduled?

Thanks for your help!

DateDiff("d", [Date_Fm], [Date_To])

will calculate the number of calendar days between the two dates. If you need
*business* days, excluding weekends and holidays, see

http://www.mvps.org/access/datetime/date0012.htm

or

http://www.accessmvp.com/djsteele/Diff2Dates.html