circular reference in querys

  • Thread starter Thread starter Claire Rohan via AccessMonster.com
  • Start date Start date
C

Claire Rohan via AccessMonster.com

Hi there

I have a query (based on my main table) which includes a calculated
expression field called Leverage. I need to create a field called Current
Weighting which iscalculated as: Leverage of each record/sum of Leverage for
all records. I havent been able to make this work without creating a circular
reference. Can anyone help?

Many thanks
 
Create a separate query that only creates the sum of all Leverages. Then use
that query within your other query, as the source of the summation.
 
Back
Top