Cumulative Percentage and dsum

[treyxman]

Hi all,

I have been trying to figure out this problem for days and have been surfing the web for countless hours and can't come up with a solution....Ultimately I am trying to create a query that allows for multiple pareto analysis charts to be created.

I have the charts and they work for the most part, however the cumulative percentage isn't working right. I have tried the syntax from http://support.microsoft.com/kb/304180 but this won't work for me since it just reads a bunch of 1s in the Cumpct column. From what I've learned on the web I need to add a tiebreaker in the syntax, but when I do this I just get a cumulative percentage that makes no sense.

Anybody have any ideas?? Thanks!
-Trevor

[treyxman]

Here is my version of the microsoft help that i got from the link..

CumPct: DSum("[CountOfItem #]","tblMainReports","[CountOfItem #]>=" & [CountOfItem #Total] & "")/DSum("[CountOfItem #]","tblMainReports")

and here is the syntax that I have come up with, using the Issue ID as a "tiebreaker"...

CumPct: ( DSum("[CountOfItem #]","tblMainReports", "[CountOfItem #]>=" & [CountOfItem #Total] & " AND [Issue ID]<="&[Issue ID]))/DSum("[CountOfItem #]","tblMainReports")