Search results for query: *

SELECT t.[material #], Count(*) AS COO_Count FROM (SELECT DISTINCT origin, [material #] FROM [COO Initial] WHERE origin <> "" GROUP BY origin, [material #]) AS t GROUP BY t.[material #]; I have tried to accomplish the same goal in many ways, by structuring my table differently, and nothing has...

Hello, I have a table structured in the following way: Part COO 1a1 US 1a1 CN 1a1 MX 1b1 US 1c1 US 1c2 US 1c3 US 1d1 MX 1d2 US I would like to do a Count Distinct on the COO column grouped by Part to return only those parts that have more than...

Thank you for that, I believe it is what I'm trying to accomplish. However, is there a way to incorporate the blank fields? In other words, what I would really like to show is a count of unique fields by part and fac combo (Example below) and then gather a list of all parts that have more than...

I have a table structured in the following way: Part Fac1 Fac2 Fac3 Fac4 Fac5 Fac6 Fac7 Fac8 1a1 US US MX US US 1a2 CN CN CN CN 1b1 CN US MX CN 1b2 US US US US US US 1c1 US US US 1c2 CN CN CN CN CN 1c3 US CN I actually have 34 columns, and used the following type of...

Thanks to all of you. This is very helpful. However, this may seem obvious but I'm having issues with the syntax on multiple left joins... I have ended up with 34 tables (!!) actually, and when trying to join each I'm getting the error, "Syntax error (missing operator) in query...

I am working with multiple tables (6 at this point, but could be more in the future). Each table represents a separate facility and has a list of part numbers and countries of origin (COO). Each table has a different number of parts and some parts are on some tables but not others. What I...