microsoft.public.access

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