Running sum cumulative

[Denjuan]

I have a table with fields called: Categorization, % of sales. I want to cumulate this field. It must look like:

Categorization %of sales cum:
candy 5% 5%
Gum 2% 7%
Chips 4% 11%


I want to do this in a query and not in a report. I hope somebody can help me.

 

[dcx693]

Check out the info in this thread