hi shuie,
thanks very much. I'm not very proficient with VBA, so I guess, i wont be able to achieve a report. basically, I just wanted the report to show the report with the totals. Do you think I would be able to get the totals for each date in the bottom of the each column. can you please help...