Subform Calculations

[cel504]

Could anyone tell me, is it possible do a summary calculation of a subform
and show the results on the main form. If I have a form and there is a
subform displayed on it. One of the fields on the subform, is say a job cost,
as the additional records are entered on the subform, the cost is calculated
and displayed in a text box on the main form.

Any ideas, on if this is possible. Many thanks.

 

[ruralguy via AccessMonster.com]

You can put an invisible TextBox in the Footer of the SubForm named txtTotal
and set the ControlSource of this TextBox to =Sum([job cost])

Then you can have a TextBox on the MainForm with the ControlSource set to:
YourSubFormControlName.FORM.txtTotal
...using your sub form control name of course.

 

[cel504]

Many thanks for your quick reponse and I understand what you are saying, will
this work if the subform is in a datasheet view? I have tried doing what you
suggested and it displays and error message.

Any further ideas, but I will keep trying.

 

[ruralguy via AccessMonster.com]

It should work just fine in Datasheet mode. Perhaps your reference to the
control syntax is not correct.
http://www.mvps.org/access/forms/frm0031.htm

Many thanks for your quick reponse and I understand what you are saying, will
this work if the subform is in a datasheet view? I have tried doing what you
suggested and it displays and error message.

Any further ideas, but I will keep trying.

Could anyone tell me, is it possible do a summary calculation of a subform
and show the results on the main form. If I have a form and there is a

[quoted text clipped - 3 lines]

Any ideas, on if this is possible. Many thanks.

 

[cel504]

Once again many thanks for that and I will go over the it again and check it
out.

It should work just fine in Datasheet mode. Perhaps your reference to the
control syntax is not correct.
http://www.mvps.org/access/forms/frm0031.htm

Many thanks for your quick reponse and I understand what you are saying, will
this work if the subform is in a datasheet view? I have tried doing what you
suggested and it displays and error message.

Any further ideas, but I will keep trying.

Could anyone tell me, is it possible do a summary calculation of a subform
and show the results on the main form. If I have a form and there is a

[quoted text clipped - 3 lines]

Any ideas, on if this is possible. Many thanks.

 

[ruralguy via AccessMonster.com]

Post back if you are still having problems.

Once again many thanks for that and I will go over the it again and check it
out.

It should work just fine in Datasheet mode. Perhaps your reference to the
control syntax is not correct.

[quoted text clipped - 11 lines]

 

[cel504]

It worked treat many thanks for you help. I am not sure if this is possible
or not, but if you enter data in a subform say, 2 items at £2.50 each can you
get it to calculate £5.00 as you enter it. I know you would normally do this
in a query, but just interested to see if is possible, that's all.

Once again, thanks for you help and time taken.

Cel

Post back if you are still having problems.

Once again many thanks for that and I will go over the it again and check it
out.

It should work just fine in Datasheet mode. Perhaps your reference to the
control syntax is not correct.

[quoted text clipped - 11 lines]

Any ideas, on if this is possible. Many thanks.

 

[ruralguy via AccessMonster.com]

You can cause the calculating control to recalc in the AfterUpdate event of
the other control.

It worked treat many thanks for you help. I am not sure if this is possible
or not, but if you enter data in a subform say, 2 items at £2.50 each can you
get it to calculate £5.00 as you enter it. I know you would normally do this
in a query, but just interested to see if is possible, that's all.

Once again, thanks for you help and time taken.

Cel

Post back if you are still having problems.

[quoted text clipped - 6 lines]

 

[cel504]

I think I may have confused you a little, what I was trying to get my head
around was,if it is possible to have an extra column on the subform table and
as you completed say columm one with a number, column two with a rate and the
third column would display the calculation of the first two colums. I have
done this is a query, but only interested if it was possible in a table.

Many thanks, Cel.

You can cause the calculating control to recalc in the AfterUpdate event of
the other control.

It worked treat many thanks for you help. I am not sure if this is possible
or not, but if you enter data in a subform say, 2 items at £2.50 each can you
get it to calculate £5.00 as you enter it. I know you would normally do this
in a query, but just interested to see if is possible, that's all.

Once again, thanks for you help and time taken.

Cel

Post back if you are still having problems.

[quoted text clipped - 6 lines]

Any ideas, on if this is possible. Many thanks.

 

[ruralguy via AccessMonster.com]

It is a calculated value and therefore should not be in a table. There are
no triggers in Access so there is nothing in the table to keep that field
accurate.

I think I may have confused you a little, what I was trying to get my head
around was,if it is possible to have an extra column on the subform table and
as you completed say columm one with a number, column two with a rate and the
third column would display the calculation of the first two colums. I have
done this is a query, but only interested if it was possible in a table.

Many thanks, Cel.

You can cause the calculating control to recalc in the AfterUpdate event of
the other control.

[quoted text clipped - 13 lines]

 

[cel504]

Thanks for that and I undestand what you are saying.

Cel.

It is a calculated value and therefore should not be in a table. There are
no triggers in Access so there is nothing in the table to keep that field
accurate.

I think I may have confused you a little, what I was trying to get my head
around was,if it is possible to have an extra column on the subform table and
as you completed say columm one with a number, column two with a rate and the
third column would display the calculation of the first two colums. I have
done this is a query, but only interested if it was possible in a table.

Many thanks, Cel.

You can cause the calculating control to recalc in the AfterUpdate event of
the other control.

[quoted text clipped - 13 lines]

Any ideas, on if this is possible. Many thanks.