Calculated Total on Form

[Guest]

Hi, I have a form that has an unbound field with a calculated subtotal.

What I would like to know, is how can I make a another field that has the
total sum of all records using the results of the above calculated subtotal.

 

[Guest]

Just to be more clear:
I have an unbound calculated field [subtotal]

I have 20 records total

I would like to add in my Form next to my [subtotal] field another unbound
calculated field that has the sum of the field [subtotal] for all 20 records.

Thanks.

 

[Guest]

BTW, I've tried =SUM([fieldname]) but that does not work. Any thoughts? Do
I have to put my calculated field in a table? I did'nt because I understood
that that was bad to do.

Thanks.

Just to be more clear:
I have an unbound calculated field [subtotal]

I have 20 records total

I would like to add in my Form next to my [subtotal] field another unbound
calculated field that has the sum of the field [subtotal] for all 20 records.

Thanks.

Hi, I have a form that has an unbound field with a calculated subtotal.

What I would like to know, is how can I make a another field that has the
total sum of all records using the results of the above calculated subtotal.

 

[storrboy]

BTW, I've tried =SUM([fieldname]) but that does not work. Any thoughts? Do
I have to put my calculated field in a table? I did'nt because I understood
that that was bad to do.

Thanks.

Just to be more clear:
I have an unbound calculated field [subtotal]

I have 20 records total

I would like to add in my Form next to my [subtotal] field another unbound
calculated field that has the sum of the field [subtotal] for all 20 records.

Thanks.

Hi, I have a form that has an unbound field with a calculated subtotal.
What I would like to know, is how can I make a another field that has the
total sum of all records using the results of the above calculated subtotal.

Can I assume this is a for in datasheet or continuous form view? Where
on the form is [Subtotal] - in the detail section? If so I believe the
new texbox should be in the form footer section and have a control
source of =Sum([SubTotal])

 

[Guest]

I tried that. I have an unbound field in the form header. in that unbound
field i have the equation: =[Hrs to Dollars]+[Material]

that equation works fine for each form. What I need is to also show what
the total of all my Subtotals.

BTW, I've tried =SUM([fieldname]) but that does not work. Any thoughts? Do
I have to put my calculated field in a table? I did'nt because I understood
that that was bad to do.

Thanks.

Just to be more clear:
I have an unbound calculated field [subtotal]

I have 20 records total

I would like to add in my Form next to my [subtotal] field another unbound
calculated field that has the sum of the field [subtotal] for all 20 records.

Thanks.

"Chipmunk" wrote:

Hi, I have a form that has an unbound field with a calculated subtotal.

What I would like to know, is how can I make a another field that has the
total sum of all records using the results of the above calculated subtotal.

Can I assume this is a for in datasheet or continuous form view? Where
on the form is [Subtotal] - in the detail section? If so I believe the
new texbox should be in the form footer section and have a control
source of =Sum([SubTotal])

 

[Guest]

I guess this situation warrants doing a calculation in a bounded field, that
is the only way I can get this to work.

I tried that. I have an unbound field in the form header. in that unbound
field i have the equation: =[Hrs to Dollars]+[Material]

that equation works fine for each form. What I need is to also show what
the total of all my Subtotals.

BTW, I've tried =SUM([fieldname]) but that does not work. Any thoughts? Do
I have to put my calculated field in a table? I did'nt because I understood
that that was bad to do.

Thanks.

:
Just to be more clear:
I have an unbound calculated field [subtotal]

I have 20 records total

I would like to add in my Form next to my [subtotal] field another unbound
calculated field that has the sum of the field [subtotal] for all 20 records.

Thanks.

:

Hi, I have a form that has an unbound field with a calculated subtotal.

What I would like to know, is how can I make a another field that has the
total sum of all records using the results of the above calculated subtotal.

Can I assume this is a for in datasheet or continuous form view? Where
on the form is [Subtotal] - in the detail section? If so I believe the
new texbox should be in the form footer section and have a control
source of =Sum([SubTotal])