I have seen a few posts relating to this but have not been able to implement the answers to solve my problem so my apologies if this is a duplicate post!
I have a database with information on our company's computer assets. Of course, there's a table with a unique record for each workstation, printer, server, etc. Each has a unique number. Each of these assets has a set of components in another table (like a mouse, keyboard, etc), and an associated price. I need to create a report that can display the total money in the asset (sum of the cost of the components for all assets of that type), but also the number of that type of asset that the company owns. So it would look like this:
Asset: Computers Count: 53 TotalCost: $102,350
Asset: Printers Count: 4 TotalCost: $26,000
And so on...So I need to group by the asset type and put the component cost in the details section so that I can do running totals, right? I get everything to work except the count. it counts the number of components, not the number of assets in the group. {A computer with 5 components would count as "5" not as "1"} So how do I count the group items, not the detail items? I have seen some cryptic answers to this problem, but all entail writing some code in the sql expression or formulas, which I'm not exactly comfortable with yet. I can get it to work if I take the cost out of the details section but I believe I need it in there to calculate the $total.
Any help? When I figure out how to do this, I'll be able to add a top level group to group assets by branch office.
Thanks so much in advance!!
Katie
IP Logged
