HOTWATT
asked on
Adding columns question
I have a report that shows part numbers and what we have on order for these certain part numbers. Each line is a different order. So in my query there may be a part number with 3 or 4 lines and each line has a different on order balance. Basically I am trying to figure out how to add the multiple on order quantities and display them so each part number will have one line which will be total on order quantity. I attached a couple documents you can look at might help you understand more. Any help with this would be much appreciated!
SQL.PNG
example.PNG
SQL.PNG
example.PNG
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You're welcome
ASKER