microsoft.public.access

Let's start with a clear picture of your form and subform design -- include
the SQL statements for the form's and subform's RecordSources. Tell us about
the actual data -- field names, table names, examples of data values.

If you're not including the "subsubgoal" data in the subform, then how are
those data associated to the subgoal data?
--

Ken Snell





wrote in message
news:1192291117.349595.243670@k35g2000prh.googlegroups.com...
> 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.
>