L
Les Coover
I have a subform that totals a list of values, then
I place this sum in a form. The Control Source for the
field containing the sum is as follows.
Control Source: =[subfrmBasis].Form!TotalShares
Now I want to include this sum in a query that uses
other fields in the form (in other words fields from the
table the form is based on).
I don't understand how to get the sum value in my query.
Here are some things I have considered.
The control source for the field cannot be based on both a field in a table
and calculated field.
I tried mimicking the value to another field but have been unsuccessful.
Me!No_Shs=[Forms]![frmMutualFundSymbol]![SumTotalShares] wont work.
Anyone know a good way to do this.
Thanks in advance, if I don't thank you later.
Les
I place this sum in a form. The Control Source for the
field containing the sum is as follows.
Control Source: =[subfrmBasis].Form!TotalShares
Now I want to include this sum in a query that uses
other fields in the form (in other words fields from the
table the form is based on).
I don't understand how to get the sum value in my query.
Here are some things I have considered.
The control source for the field cannot be based on both a field in a table
and calculated field.
I tried mimicking the value to another field but have been unsuccessful.
Me!No_Shs=[Forms]![frmMutualFundSymbol]![SumTotalShares] wont work.
Anyone know a good way to do this.
Thanks in advance, if I don't thank you later.
Les