Report totalling

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report in which I am totally monthly sales inquiries . I have a text box with a static number in which is the weekly goal. The report is first grouped by month and secondarily by week. The text box is in the week group footer. I would like to know how to add the text boxes in the monthly group footer for a tally of the goals. I can't just add a static number because some months have 5 weeks vs 4

The text box is simply =5 in the control source. This works perfectly in the weekly section as it is subtracted from the inquiry field to show a net gain/loss etc

Hopefully I have explained this adequately

I'm a newbie at this, so your help is greatly appreciate
 
Rene

On a side note, it sounds like you are saying that a week of 7 days, early
in the month, has the same goal (5) as a week at the end of the month, with
maybe only one day (check February!)?

One approach might be to add code in the OnFormat event for the weekly
footer. The general concept is that every time the group (weekly) footer
formats, it adds 5 to a control in the monthly group footer -- something
like:
([MyMonthlyTotalGoal] = [MyMonthlyTotalGoal] + 5)

JOPO (just one person's opinion)

Jeff Boyce
<Access MVP>
 
Back
Top