Count Number of Days Code Help

[Dave]

I have a sub-form named Time and Hours
On this form it has a Text Box with it's Control Source set to Work Date
and it's Name is WorkDate Format is m/d/yy
On the Form Footer are Totals for the Form, it has multiple records.
I need for the unbound text box named Text98 to add up the total Number of
Days Spent on this Job, it is located on the Form Footer as well.


Thanks,

Dave

 

[Frank Stone]

I am not sure i understand you but to do what you want,
textbox98 should have a expersion as the control source
that subtracts workdate(i think-anyway start date) from
now(). that will give you total days worked.

 

[Dave]

Ok, but what would the format for the Format Type???

 

[Dave]

What I really need is the difference between the oldest and latest dates on
form, not date()

Thanks,