group totals / grouping by category.

[wvdba]

Hi,
i have an app that lists sales reps and the actions that they did i like to be able to list each sales rep and give a total for each action they did and a grand total for the rep at end of report.
i can make up the report from the data and list each rep and his actions. but i want the rep to repeat once and the actions repeat once. the report should look like this:
rep action date
---- ------ ----------
john visit 09/01/2009
visit 09/07/2009
visit 09/15/2009
---- ------ ----------
3
phone 09/02/2009
phone 09/09/2009
phone 09/13/2009
phone 09/17/2009
---- ----- ----------
4
what's the mechanism to do this in the reports?
thanks.

 

[dhookom]

I'm not sure why you didn't as this question in the Reports forum. However, use the Sorting and Grouping in the report design view.

Duane
Hook'D on Access
MS Access MVP