field calculation problem

  • Thread starter Thread starter Joe Willie
  • Start date Start date
J

Joe Willie

Is it possible to have a total of time in a field that is
a combination of two date formated fields?

For example -
one field might show 8/1/3 and another field might show
8/8/3. I would then want the third field to show 7 for the
amount of days between the first two fields. Any help is
truely appriciated.

Thank you, Joe
 
In a Query you can simply calculate the difference:

DaysBetween: [DateField2] - [DateField1]
 
Back
Top