running SUM in query - HELP!

[chutcheson]

We want to create a running sum over a group and are not sure if we have the criteria correct. Anyone have any ideas?

The groups are identified in the field tps cat.

CODE:
Total percent: DSum("[Summary Log cost info 4]![percent]","[Summary Log cost info 4]","[Tons per stems] > .5")

 

[dhookom]

Your DSum() is written to return the exact same value for each record in your query. I would expect to see a where clause that references a field in your query.

Maybe you should tell us about your table(s) and desired display.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]