Hi everyone!!!

I need help in summing these data by date.



How do i do this using one MSFlexgrid? After summing it, the output should only have 3 rows.

The expected output should be like this.

261 | 5986.67 | $652.9091 | 700.44 | $84.0528 | 2/1/2011
51 | 1959.09 | $201.2143 | 233.55 | $28.0260 | 2/2/2011
220 | 4379.10 | $475.3718 | 199.66 | $23.9592 | 2/3/2011

Any help is greatly appreciated.