Grouping

  • Thread starter Thread starter PieterC
  • Start date Start date
P

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
 
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>
 
Back
Top