Grouping

[PieterC]

I need to group some data and I am having a problem
My report is coming out like this.

File Combo1 Combo2 Combo3
1 5 0 0
1 0 6 0
1 0 0 1
2 7 0 0
2 0 0 1

I want it to look like this

File Combo1 Combo2 Combo3
1 5 6 1
2 7 0 1

 

[Jeff Boyce]

Pieter

Reports are based on data coming from queries or tables. Without some idea
of your underlying data structure, or the query you're using, this is only a
guess. Could you use a Totals query, grouped by your "File" field, summing
your "Combo" fields?

Good luck

Jeff Boyce
<Access MVP>