In contract db I calculate monthly sales. In find mode I select individual sales rep to calculate monthly sales for the rep. Now I want to run a report for all sales reps showing their individual performance.

I would like to save the reps monthly actual in the rep db where there is a record for each rep.

Of course there is other stuff like quota and year to date actual versus quota that I think I can handle.

Not sure exactly what you're asking, but one word of advice might be sub-summaries (what, you thought I'd say "plastics"?).