I need help with a SQL statement

[Guest]

I have a table that has two fields that I want to work with. The fields are
called Distributors and Group Number. There are many Distributors and many
Group Numbers. The Distributors have many listings with the same group.
There are some Distributors that have no Group Numbers. I want to create a
list that has the Distributors listed once that have 1 or more Group numbers
associated with them.

Thank you for your help.

 

[OfficeDev18 via AccessMonster.com]

SELECT Distributors FROM YourTableName WHERE [Group Numbers] Is Not Null
GROUP BY Distributors;

 

[Guest]

Sheila,

Thanks for the input but your SQL provides multiple copies of the
Distributor when I only what to see the output to show the unique ones, no
matter how many there are. Those that appear in the list must be made up of
those Distributors that have group numbers associated with them. I don't
want the list to include Distributors that are in the table but do not have a
group number.

Does that help you understand what I am shooting for?

Any other suggestions?
Thanks

 

[John Spencer]

SELECT DISTINCT Distributors
FROM YourTable
WHERE [Group number] is not null

 

[Guest]

Hi there

Try something like this:
SELECT Table2.DIstributor, Table2.Group_Number, Count(Table2.Group_Number)
AS CountOfGroup_Number
FROM Table2
GROUP BY Table2.DIstributor, Table2.Group_Number
HAVING (((Count(Table2.Group_Number))>0));

You'll need to replace table and field names as appropriate

HTH

Sheila