I have created a fairly simple query here selecting all order lines in a “Planned” or “Released” status, where Part No is like “-”, and any value in part description. I then sum the Sales Qty for the Part No that is grouped. Our issue is our Part Description is not unique so I really do not need to separate by part description, but if I do not group with it the field does not return values. As you can see for Part No 100-ST50 we have a description of Diamond 20# and a description of Diamond 20lb, I simply need the first description shown for a reference and need the subtotal for part no to include all entries so the subtotal for part no 100-ST50 should be 950. I do not know how to have SQL simply return the first distinct value for part description.
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
