|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 14th, 2005, 07:39 PM
|
|||
|
|||
Calclation on a form
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 
|
|
#2
November 14th, 2005, 08:22 PM
|
|||
|
|||
|
Calclation on a form
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 " wrote: 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
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Search facility | tezza | General Discussion | 13 | February 18th, 2010 12:26 AM |
| Move feild entries from form to form using global variables | JackCGW | General Discussion | 11 | November 14th, 2005 05:22 AM |
| Need Help In Printing Current Record in Specific Report | RNUSZ@OKDPS | Setting Up & Running Reports | 1 | May 16th, 2005 09:06 PM |
| Dates in a listbox connected to a form... | RusCat | Using Forms | 13 | November 25th, 2004 02:31 AM |
| auto entry into second table after update | Tony | New Users | 13 | July 9th, 2004 10:42 PM |
Linear Mode
