Question

[aroraaj]

I'm desiging a query to find out which of the suppliers are at gold standard.

Here's what I have so far:

SELECT tbl_Data.[P1 Production Source], tbl_Gold_Data.Gold
FROM tbl_Data INNER JOIN tbl_Gold_Data ON tbl_Data.[P1 Production Source] = tbl_Gold_Data.Supplier
WHERE (((tbl_Gold_Data.Gold)="Yes") AND ((tbl_Data.[Engine Model])="MRJ"));


in P1 Production Source field it shows the same suppliers is there a way to only show it once. And also is there a way to get a count of all together how many gold suppliers are there?

 

[Rabbie]

Does SELECT DISTINCT tbl_Data.[P1 Production Source], tbl_Gold_Data.Gold
FROM tbl_Data INNER JOIN tbl_Gold_Data ON tbl_Data.[P1 Production Source] = tbl_Gold_Data.Supplier
WHERE (((tbl_Gold_Data.Gold)="Yes") AND ((tbl_Data.[Engine Model])="MRJ")); give you what you want?

Also try
SELECT Distinct tbl_Data.[P1 Production Source], tbl_Gold_Data.Gold,Count(tbl_Gold_Data.Gold)
FROM tbl_Data INNER JOIN tbl_Gold_Data ON tbl_Data.[P1 Production Source] = tbl_Gold_Data.Supplier
WHERE (((tbl_Gold_Data.Gold)="Yes") AND ((tbl_Data.[Engine Model])="MRJ"));

May give you the count.

 

[aroraaj]

the second one doesn't work.

but the first one work it only shows one supplier...thanks!

do you know how i can count that?