Hi
Thanks for all the help ive been getting off the forum. Been helping me a lot.
So I have a little bit of a dilemma here.
So this is a report I have drawn from a query.
I now have to work out average scores of the yellow and the blue vertical columns.
The problem is that on every report these values changes based on what level the employee is on.
So if on level 11 only the light pink horizontal fields are applicable and if level 9 only the light blue horizontal fields are applicable.
Is there way to group these fields together and then write IF statement like this in the control source (not sure how to group fields?) :
IF (level(field) >=9 or <=11, sum(group1) / (numberoffieldsingroup) ----- This will then give me the average score - So im not sure how to group these fiields and also not sure how to program a count of fields in group to divide it by.
Hope this makes sense..