Sales Report line percentage of total sales

[Dbless]

Trying to write a sales report where each sales rep has a total line on the report. On each total line I need to add the percentage of total sales for that sales rep compared to the entire report total sales. How would I accomplish this?

Pre-thanks to anyone

 

[PaulBricker]

Here's what you can try.
1. Create a Group Header for your Sales Reps
2. In the Group Footer add an unbound textbox, I'll call txtSubTotal,with the control source set to
=Sum([Sales])
3. In the Report Footer, add an unbound textbox, I'll call txtTotal, with the Control Source set to
=Sum([Sales])
4. In the Group Footer add another unbound textbox with the control source set to
=txtSubTotal/txtTotal
Set the Format to Percentage.
That should do it.

Paul