Including a Sum from a calculated field in a query

  • Thread starter Thread starter Les Coover
  • Start date Start date
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 think I figured this out. If I make a totals query of what I want to
total and then
include one of the fields from the totals query in my "regular" query it
seems to work well.

I also noticed that I can hide the particular associated queries so I won't
inadvertently delete
them later on.

Les
 
Back
Top