I need help with a SQL statement

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SailFL - 16 Nov 2005 16:56 GMT

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.

Signature

SailFL

Reply to this Message

OfficeDev18 - 16 Nov 2005 17:29 GMT

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

>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
[quoted text clipped - 4 lines]
>
>Thank you for your help.

Signature

Sam

Reply to this Message

John Spencer - 16 Nov 2005 21:08 GMT

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

>I have a table that has two fields that I want to work with. The fields
>are
[quoted text clipped - 8 lines]
>
> Thank you for your help.

Reply to this Message

Sheila D - 16 Nov 2005 22:03 GMT

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

> 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
[quoted text clipped - 4 lines]
>
> Thank you for your help.

Reply to this Message