I need Help with a DSUM function in an Access query

[anaej]

I'm attempting to create a running sum for a percent field I calculated but I can't get the running sum to work and I'm not sure what I'm doing wrong. The fields in my total query are year(group by), month(group by), category (group by), supplier (group by), total cost (sum), total wt (sum), and percent (sum). I want a running sum for each category by month and year. I have attempted a variety of combinations of criteria but I keep getting a total for the criteria instead of a running total. I tried first to just get a running sum by year but I couldn't get my formula to work. What am I doing wrong?

Total percent: DSum("percent","Summary Log cost info 4","year <=" & [Year] & " ")

 

[xlbo]

you would be better off posting here: forum701

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question