IowaGuy
Dec 3, 2007, 11:11 AM
Ok..
I am trying to make a report that will sum up the results for 3 columns in the same table based on date.
I have been using the wizard but all my results come out like this.
1/4/2007 100 100 5
1/4/2007 150 190 0
1/4/2007 180 140 0
1/5/2007 200 170 0
1/5/2007 110 175 0
All the columns are in the same table
For now, I need is this.
1/4/2007 430 290 5
1/5/2007 310 345 0
Any step by step help would be really apprecaited!
I am trying to make a report that will sum up the results for 3 columns in the same table based on date.
I have been using the wizard but all my results come out like this.
1/4/2007 100 100 5
1/4/2007 150 190 0
1/4/2007 180 140 0
1/5/2007 200 170 0
1/5/2007 110 175 0
All the columns are in the same table
For now, I need is this.
1/4/2007 430 290 5
1/5/2007 310 345 0
Any step by step help would be really apprecaited!