Question: How do you turn off autocal in a form?

[Noreen]

Hi,

I don't want a pivotchart to calculate any autocal in the data field drop area , just show the number without sum, avg, min, max etc

Is this possible?

Thanks in advance for your help

 

[datAdrenaline]

Well, a pivot chart is an form of an aggregate query, so if you know your values will be repeating and you just want that value, you may be able to use the First() aggregate function.

 

[Noreen]

Well, a pivot chart is an form of an aggregate query, so if you know your values will be repeating and you just want that value, you may be able to use the First() aggregate function.

I apologise, I'm fairly new to access, I don't understand what you mean. Could you please explain further?

I want to compare an average for a class across different modules to the actual result a student got. The chart is calculating an average result for a student across all modules, I would like to stop this. I have the query designed in such a way that it brings up the average for the class and the actual result for the student so the problem resides in the chart (from my understanding of access.

Thanks a million for your help