Help with a calculated field.

[George Hewitt]

Hello Guys,

So i today I am wondering if anyone can guide me with a calculation im trying to achieve.

I want to take the sum of all records 'cost' i.e. record 1 - 2
record 2 - 4
record 3 - 3

I want to take the sum and put it in a calculated field and use it to divide it by a predefined value 'no of responses.'

So I make the field in the query -> Calcfield: (Sum([cost])/[responses])

Im pretty new to this and i don't understand why this won't work? Is it something to do with the row Group by (total.)

Thanks for any help

George.

 

[epiek]

If group mode is on in your query, try changing the word Group By to Expr.

If this does not work, create a new query based on you first query and do the calculation in the phase 2 query

 

[Mihail]

Show us the relationships window (a pic)

 

[George Hewitt]

Cheers for the help Epiek did the trick.