Solved MS Access - Query Chart update, Not to Count but to Average

[Fitzi]

Hello,
I don't have that much experience in Ms Access, and I found this database that would help me

In this database, the underlying querys executes the Count function and I would like to make an Average of RealizatPcr.
In principle, I would like to replace count ID Count(EventID) to Average of RealizatPcr everywhere in VBA code and Query, and to function correctly.

I tried everything I knew, but without results.
If someone would help/guide me to the steps to follow, I would appreciate it very much!

We also have the file attached.

Thank you in advance

 

[arnelgp]

is this what you meant.

 

[Fitzi]

is this what you meant.

Yes..
Thousands of thanks!

I struggled for 2 days to try this... and it didn't work.

Thank you for your quick and correct solution!