Sub form totals

[peashoe]

I have a sub form within a form that has Team Jacket sizes. How can I
add a total at the bottom on the column. For example: (the name is a
drop down, the sizes are entered manually)

Name Small Medium Large
Team 1 2 0 1
Team 2 3 3 3
Team 3 0 2 1
5 5 5 < -------- how do I get
these to display in the subform?


Thanks in advance
Lisa

 

[Guest]

In the subform footer add textbox for each with record source as
=Sum([YourField)

 

[peashoe]

Karl,
I tried adding it at the bottom of the textbox (but it just appeared at
the end of the row) and at the footer it does not appear at all? The
sub form kind of looks like an excel spreadsheet with columns and rows.

~L~

In the subform footer add textbox for each with record source as
=Sum([YourField)

I have a sub form within a form that has Team Jacket sizes. How can I
add a total at the bottom on the column. For example: (the name is a
drop down, the sizes are entered manually)

Name Small Medium Large
Team 1 2 0 1
Team 2 3 3 3
Team 3 0 2 1
5 5 5 < -------- how do I get
these to display in the subform?


Thanks in advance
Lisa

 

[peashoe]

Karl,
I tried adding it at the bottom of the textbox (but it just appeared at
the end of the row) and at the footer it does not appear at all? The
sub form kind of looks like an excel spreadsheet with columns and rows.

~L~

In the subform footer add textbox for each with record source as
=Sum([YourField)

I have a sub form within a form that has Team Jacket sizes. How can I
add a total at the bottom on the column. For example: (the name is a
drop down, the sizes are entered manually)

Name Small Medium Large
Team 1 2 0 1
Team 2 3 3 3
Team 3 0 2 1
5 5 5 < -------- how do I get
these to display in the subform?


Thanks in advance
Lisa

 

[Guest]

I tried adding it at the bottom of the textbox
That is not what I said to do.

Add a textbox for each in the subform footer with record source as
=Sum([YourField])

 

[peashoe]

but that is what I am saying I tried both - including adding the
textbox in the footer - but it does not appear in the subform at all?

~L~

That is not what I said to do.

Add a textbox for each in the subform footer with record source as
=Sum([YourField])

 

[peashoe]

never mind, I found the answer - I needed to change my Default view of
the subform to Continuous form and not Datasheet

Thanks
~L~

but that is what I am saying I tried both - including adding the
textbox in the footer - but it does not appear in the subform at all?

~L~

I tried adding it at the bottom of the textbox

That is not what I said to do.

Add a textbox for each in the subform footer with record source as
=Sum([YourField])