Cumlative total

[edmac2]

I am writing a report that searches a stockroom database, I would like to find out the total number of an item that is listed to say a cost center. The problem I am having is that when one item is issued more than once it only shows up once, you could have issued it 20 times but only have 1 show up. What I would like to do is for that one item is to show the name once but show where it was issued to and the total number of units issued to that center.

 

[LindaC]

How about grouping by cost center then item.&nbsp;&nbsp;In the detail put your fields - item_name, cost_center.&nbsp;&nbsp;Right click on the item_name field and choose 'Insert Summary', then choose maximum and place in the group footer. Do the same for cost_center.&nbsp;&nbsp;Then right click on the item_name field again and choose 'Insert Summary', then choose count. Make sure you are not Selecting Distinct values.&nbsp;&nbsp;If that is on you will not select identical records. <p>LindaC<br><a href=mailto:lcastner@co.orange.ny.us>lcastner@co.orange.ny.us</a><br><a href= > </a><br>