Reports not returning expected averages

[Nymandus]

Good morning

I fear my problem may stem from my overall design but I hope you all can help.

I am new to Access and programming for that.

My database is set up to track call evaluations with 4 fields for number data (S, A/C, C/E and B) each of these have a possible point total. I also have a percentage field to track out of total possible points.

When I run my query I get a list of each of the totals for each of the evaluations with the associates names (as expected)

this is where my problems come out and I begin to bang my head against the desk...:banghead:

I take that query and try to run a report wizard to give me an average socre for each associate. and the system returns averages of 0 or an odd number that does not make sense.
when I use the =Avg([fieldname]) process I get an accurate average of the total but can not get it to do a "subtotal" for each associate.

please let me know what information I can provide to aid in your answer...

 

[JHB]

Have you set up a grouping in your report, (not in the query, but in the report), for the associates names?
Else post your database with some sample data.