Calclation on a form

J

jerry

Access 2003.
I have a field on a form that shows the number of days between 2 dates

=Datedif("D",[Arrive],[Depart]).
This shows the information in a subform in datasheet view. I have a
text box on a form and would like to show the total of the dates. I
have tried placing a box in the footer and referencing that with a sum
total but the count is incorrect.

TIA
Jerry
 
S

Sprinks

Jerry,

Summary fields must reference fields in the RecordSource. For example, if
your first calculated control is named MyDateDiff, then:

=Sum(MyDateDiff) will not work. Use the following instead:

=Sum(Datediff("D",[Arrive],[Depart]))

Sprinks
 
Top