Re: I need help with a SQL statement

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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

SailFL wrote:
>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.

--
Sam

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200511/1
.

Relevant Pages

  • Re: I need help with a SQL statement
    ... SELECT DISTINCT Distributors ... > SailFL ... Prev by Date: ...
    (microsoft.public.access.queries)
  • Re: cheap ball mills
    ... (same price as my distributors). ... LLoyd ... Prev by Date: ...
    (rec.pyrotechnics)
  • Re: $100 Laptop - How do I get one?
    ... > How will the distributors of these machines ensure that they will stay ... > could do was to watch it skitter across the floor. ... Prev by Date: ...
    (comp.sys.mac.portables)
  • Re: Sopranos, think they will go cheap?
    ... Dan H. wrote: ... > I doubt it, not out of the operators or distributors anyway, still too ... of it cheap (as long as they can keep it working, stupid flippers) ... Prev by Date: ...
    (rec.games.pinball)
  • LatticeXP availability
    ... Anybody knows when LatticeXP parts will be available over distributors ... Less than 25 pcs. ... Sigma Lab. ... Prev by Date: ...
    (comp.arch.fpga)