microsoft.public.access

On Oct 13, 11:22 am, "Ken Snell \(MVP\)"
wrote:
> Put a textbox in the subform's Form Footer section. Set its Control Source
> to
> =Sum([NameOfFieldThatYouWantToSum])
>
> --
>
> Ken Snell
>
>
> wrote in message
>
> news:1192288391.517959.269730@q5g2000prf.googlegroups.com...
>
>
>
> >I have a project for a client that is essentially goals and subgoals,
> > so for instance, you have goal 1 and subgoal 1.1. I've created a table
> > tblBudget with fields BudgetLineID, BudgetGoalNumber, Amount and
> > BudgetCategory (which comes from a separate categories table). I
> > created a form with a subform to enter the different budget amounts,
> > it opens from the form which you enter the goals and takes the goal
> > number as a filter for the budget form. The client would like the
> > budget to display the sum of all the subgoals, as well as have the
> > opportunity to enter ine items for that goal.
>
> > So for instance, if I open the budget form for goal 1, it has the
> > subform which I've already created which shows you the line items for
> > goal 1, and then has another box which has a sum of goals 1.1, 1.2,
> > 1.1.1, etc.
>
> > Any hope? Thanks!- Hide quoted text -
>
> - Show quoted text -

I do have a box on the subform that sums up the totals on the subform,
but the part i'm having trouble with is getting the other subgoals.
For instance, the subform has line items for goal 1.1, and I need to
have the total of goals 1.1.1, 1.1.2, 1.1.1.1, etc., and those goals
are not on the subform. It's essentially the sum of goal 1.1*, I just
don't knwo how to code that. Thanks.