Formula for accumlative totals of a table cell

[Guest]

I have a continious for with a labelled table cell. In this cell are numbers
signifying amounts of people. I would like a running number of people in my
header, does anyone know how to do this, or what formula I would use to have
that accumilating number in my header.

 

[Joseph Meehan]

I have a continious for with a labelled table cell. In this cell are
numbers signifying amounts of people. I would like a running number
of people in my header, does anyone know how to do this, or what
formula I would use to have that accumilating number in my header.

I am not at all sure what you want.

Do you mean you want an input form that will keep a running total?

Tables don't do calculations they only store data. They don't even keep
data in any specific order.

 

[Guest]

Thanks for the reply!

I was afraid I would hear that. Ya I was looking to get an accumlative total
of all the values(numbers) in one continious form. Each entry in the
continious form has an Identicall cell "number of attending" I would like a
cell in my header of that form adding the numbers togerther in that cell. But
doesn't look like I can do that. Just wanted to check.

If you think of any other option please letme know. Thanks though!

 

[Guest]

Hi.

Unless I misunderstand, you are just looking to display the sum of the
numbers in each record for one particular field. If so, you should be able
to simply place a TextBox in your Form Header section, with a Control Source
similar to this:
=Sum([FieldName])

It would also be a good idea to make sure the control displaying that field
in the Detail Section does not have the same name as the field.

-Michael

 

[Guest]

Thank you very much!!! That worked perfectly, my original formula did not
have the brackets, miss the little things. I've been working too long,lol.

Again thanks!

Hi.

Unless I misunderstand, you are just looking to display the sum of the
numbers in each record for one particular field. If so, you should be able
to simply place a TextBox in your Form Header section, with a Control Source
similar to this:
=Sum([FieldName])

It would also be a good idea to make sure the control displaying that field
in the Detail Section does not have the same name as the field.

-Michael

Thanks for the reply!

I was afraid I would hear that. Ya I was looking to get an accumlative total
of all the values(numbers) in one continious form. Each entry in the
continious form has an Identicall cell "number of attending" I would like a
cell in my header of that form adding the numbers togerther in that cell. But
doesn't look like I can do that. Just wanted to check.

If you think of any other option please letme know. Thanks though!