Hey guys. Thanks for taking the time to read this. I'm new to Access so I may say things I know nothing about. I have a situation where I have a production line. Each station has three motors and each motor has to have three cables. Each one of the three can be different types. What I would like to do is sum up the quantities of each type of cable for all entries. Sounds simple enough but it still keeps baffling me. Please take a look at my screen shot. Thanks