I want to prepare some chart that show cumulative total of one field.
When I prepare the report that show accumulated of one field, I use the running sum property of field.
(A running sum is a total that is accumulated from record to record across a group, or even across the entire report.)
that is running very fast.
But in query I obliged to use this expression:
DDSB: DSum("[DDispB]";"IncDeviation";"[IPR]>=" & [IPR] & ' And' & "[IDINC]=" & [IDINC] & ' And' & "[readdate]=" & '#' & [readdate] & '#')
And when I use that query for record source of that chart the running speed of that chart decreases. Has any other way that I don’t have running problem?