Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Summing up values

Status
Not open for further replies.

JamesLynch

Technical User
Oct 30, 2002
11
GB
I have two Sales teams that need to be reported on a daily basis, with each team have four people and each of these (hopefully) make more than one sale per day.

As you can imagine there are a number of results that I need to produce, namely
- The total Sales value per Sales person(summary, not
detailed)
- The total sales per Team
- The total sales value for the entire department.

Currently I can produce a report that lists all the details for each sale, i.e. SAles person, customer, date, value,etc.

I have used the SUM value, in various shapes and forms but to no avail.
Your help would be really appreciated.



 
Hi!

Use the following query as that basis of your report:

Select SalesTeam, SalesPerson, Sum(SalesAmt) As TotalPerSalesPerson From YourTable Group By SalesTeam, SalesPerson

In the report Group on the Sales Team and put your SalesTeam textbox in the Group Header and the text boxes for SalesPerson and Total in the detail section. In the Group Footer section add an unbound textbox Sum on the TotalPerSalesPerson field. Put a similar textbox in the Report Footer section. You should get the results you are looking for.

hth
Jeff Bridgham
bridgham@purdue.edu
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top