circular reference in querys

[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

 

[mnature]

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.