Report - Sum / Group Cost

[Graveyardblues]

have a Main table listing products sent to clients. Products can be Paper
List, Labels, Cd, Etc.
Currently use a report that lists's each product for each client, by date.
Currently groups by client name,
I.E.: John Doe , Labels, 500 records 11/1/2005. Next, John Doe, List, 1000
records, 11/2/2005. Next, Jane Doe, CD, 100 Records, 11/10/2005.
Would like to include a COST for each item on the report, then List a Total
by Client As well as a Grand Total at the Bottom.
I could do this if I seperate report by product, however, I would like to be
able to generate One report that Lists all Client Products & Cost's...

Any Help or Idea's ????
Greatly Appreciated...

Aaron

 

[strive4peace]

Hi Aaron,

"Would like to include a COST for each item on the report"

I am assuming you do not have a detail line listing each item?
If that is the case, lay out the detail section -- including what you
want to add. You can set the VISIBLE property of the detail section to
False so it doesn't show and still use it's controls in your calculations

If I have misunderstood, please specify more detilas... example data
with example results would be a big help

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*