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?
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?