Date Difference in a form

  • Thread starter Thread starter Alex Martinez
  • Start date Start date
A

Alex Martinez

Hi,
I am using Access 2002 and wondering how do you do date difference between
to fields in the form? For example I have a field called assigned 11/1/2005
and another field completed 12/31/2005. What I want to do is find out the
number of days between the two fields so that the user can see this in the
form. I don't want to populate another field. Any tips will be appreciated.
Thank you.
 
Set the ControlSource of the text box to:
=[Completed] - [Assigned]
and set the Format property of the text box to:
General Number.
 
Back
Top