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 Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Group DSum

Status
Not open for further replies.

Textbox1

MIS
Oct 29, 2003
2
US
I need to find the DSum of a group heres what i got

Contractor Name Header
Contractor Name
Contractor Phone

Detail
Money Invested

Contractor Name Footer
Average Money Invested =DSum("Money","tbl_Contractor")


The DSum gives does not the SUM by group but rather gives me the SUM of Every contractors money invested.

any idea how to get the SUM of each individual contractor group?

 
This is what i want but i cant get the report to do a sum for each individual company and ideas!??

Jim's Steele
555-555-555

$1,000
$ 500
$3,000
------
$4,500

Toms Lumber
555-555-555

$3,000
$1,500
$3,000
------
$7,500

Jills Fish Food
555-555-555

$1,000
$1,000
$1,000
------
$3,000
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top