In an Inventory Report, I have the records grouped by item number, displaying the quantity ordered. If an item is in the table more than once, then each item is displayed on its own line with its own quantity ordered value.

My question is: How can I combine the multiple records so that, for instance, two items with the same item number will show up with total quantity ordered on one line in the report.

Any ideas would be greatly appreciated.

Thanks,

Steve