Calclation on a form

  • Thread starter Thread starter jerry
  • Start date Start date
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subform Datasheet Total Row 3
Sum a field in a form 1
Subform Question 2
Access Daily Entry with multiple entries per field 0
Displaying the Total from a Subform on a Main form 7
Subform and Main From calucation 14
Query Results in a Text Box 3
Query Criteria 1

Back
Top