What tables do you have? Could you explain a little deeper your base (or even share a copy)?

I think you have to create a new View in the Parts table, or maybe an auxiliary table in between. I’d need more understanding of your base

Bye!

I think I’ve figured this one out. But thanks

Could you share the solution? I’m curious now! ️

Well it’s only a crude solution. I group by the product and then use the

count summary on the field that holds the number of each.

What I really want is a new table that lists every part as a new entry with

the sum next to it.

You can see I am just trying to figure out how many of each part I need to

fulfill the current outstanding orders.