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
|
|||
|
|||
Count Number of Days Code Help
I have a sub-form named Time and Hours
On this form it has a Text Box with it's Control Source set to Work Date and it's Name is WorkDate Format is m/d/yy On the Form Footer are Totals for the Form, it has multiple records. I need for the unbound text box named Text98 to add up the total Number of Days Spent on this Job, it is located on the Form Footer as well. Thanks, Dave |
#2
|
|||
|
|||
I am not sure i understand you but to do what you want,
textbox98 should have a expersion as the control source that subtracts workdate(i think-anyway start date) from now(). that will give you total days worked. -----Original Message----- I have a sub-form named Time and Hours On this form it has a Text Box with it's Control Source set to Work Date and it's Name is WorkDate Format is m/d/yy On the Form Footer are Totals for the Form, it has multiple records. I need for the unbound text box named Text98 to add up the total Number of Days Spent on this Job, it is located on the Form Footer as well. Thanks, Dave . |
#3
|
|||
|
|||
Ok, but what would the format for the Format Type???
|
#4
|
|||
|
|||
What I really need is the difference between the oldest and latest dates on
form, not date() Thanks, |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
days and number of days | Jim | Worksheet Functions | 1 | August 18th, 2004 05:15 PM |
Trying to count the number of times a "type" of value occurs | astiller | Worksheet Functions | 2 | July 9th, 2004 03:35 PM |
Converting sequence of days into number of days | joel claes | Worksheet Functions | 1 | April 23rd, 2004 02:49 PM |
counting days vers 2 | brad | Worksheet Functions | 3 | April 20th, 2004 06:24 PM |