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
|
|||
|
|||
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
|
|||
|
|||
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 |