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