DSUM

[Guest]

Could I use DSUM() for the following issue or is there something better out
there?

i.e.

Part# Inventory Order Qty. Ending inventory Total
AAA 10 5 5
AAA 10 3 2
AAA 10 3 -1
CCC 15 5 10
CCC 15 5 5
DDD 8 1 7

Thanks,

Mike

 

[Ken Snell [MVP]]

What is the issue? It's not clear from your post.