 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / November 2006Report - Sum / Group Cost
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 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 * > have a Main table listing products sent to clients. Products can be Paper > List, Labels, Cd, Etc. [quoted text clipped - 11 lines] > > Aaron |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.