|
| 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
May 25th, 2005, 04:58 AM
|
|||
|
|||
Sum Workdays
I have a date field in my report and users will enter a beginning date and
ending date as the report parameter. I'm showing all records by date. How can I sum the total of a field (Trailers) for each work week? I've added a date field footer, but I'm now sure what to put as the control source. Thanks for your help. 
|
|
#2
May 25th, 2005, 11:53 AM
|
|||
|
|||
|
Alex:
If you have a field Trailers in the detail section that gives you a numeric count for each date, then in the footer, you'd create an unbound control (call something like TotalUnits as a name with a control source of: =Sum([Trailers]) -- Steve Arbaugh ACG Soft http://ourworld.compuserve.com/homepages/attac-cg "Alex" wrote in message ... I have a date field in my report and users will enter a beginning date and ending date as the report parameter. I'm showing all records by date. How can I sum the total of a field (Trailers) for each work week? I've added a date field footer, but I'm now sure what to put as the control source. Thanks for your help.
|
|
#3
May 25th, 2005, 03:01 PM
|
|||
|
|||
|
That totals all Trailers between beginning and ending date. I need to have a
sum at the end of each week. thanks "SA" wrote: Alex: If you have a field Trailers in the detail section that gives you a numeric count for each date, then in the footer, you'd create an unbound control (call something like TotalUnits as a name with a control source of: =Sum([Trailers]) -- Steve Arbaugh ACG Soft http://ourworld.compuserve.com/homepages/attac-cg "Alex" wrote in message ... I have a date field in my report and users will enter a beginning date and ending date as the report parameter. I'm showing all records by date. How can I sum the total of a field (Trailers) for each work week? I've added a date field footer, but I'm now sure what to put as the control source. Thanks for your help.
|
|
#4
May 26th, 2005, 01:01 PM
|
|||
|
|||
|
Alex, then you have to add a field to the report underlying query called
Week: DatePart("ww" [YourDateField]) and then in your report, group on the Week field and add a field =Sum([Trailers]) in that group footer. -- Steve Arbaugh ACG Soft http://ourworld.compuserve.com/homepages/attac-cg "Alex" wrote in message ... That totals all Trailers between beginning and ending date. I need to have a sum at the end of each week. thanks "SA" wrote: Alex: If you have a field Trailers in the detail section that gives you a numeric count for each date, then in the footer, you'd create an unbound control (call something like TotalUnits as a name with a control source of: =Sum([Trailers]) -- Steve Arbaugh ACG Soft http://ourworld.compuserve.com/homepages/attac-cg "Alex" wrote in message ... I have a date field in my report and users will enter a beginning date and ending date as the report parameter. I'm showing all records by date. How can I sum the total of a field (Trailers) for each work week? I've added a date field footer, but I'm now sure what to put as the control source. Thanks for your help.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Stumper WORKDAYS Problem | B.D. | General Discussion | 6 | February 19th, 2005 07:16 PM |
| Formula to Calculate # of Workdays | Mike | Worksheet Functions | 5 | August 30th, 2004 07:55 PM |
| calculating dates based on workdays only | Worksheet Functions | 1 | July 20th, 2004 03:48 AM | |
| Workdays (inc Sat) formula | Worksheet Functions | 13 | May 13th, 2004 03:45 AM | |
| Workdays with Saturdays for Dummies | Elena | Worksheet Functions | 6 | December 8th, 2003 06:47 PM |
Linear Mode
