Sum Workdays

[Guest]

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.

 

[SA]

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

 

[Guest]

That totals all Trailers between beginning and ending date. I need to have a
sum at the end of each week. thanks

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

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.

 

[SA]

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

That totals all Trailers between beginning and ending date. I need to
have a
sum at the end of each week. thanks

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

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.