Count Unique numbers

[Johnny]

I have two columns: Job Number and Part Number. Since
most jobs consist of more than one part the Job Number
may repeat in this column as I list all the Part Numbers.

EX.

Job Number Part Number
4587 237740
4587 237790
4587 237890
4588 010131
4588 811547


Now what I want to do is make a new query that will just
list the unigue job numbers. In the example above there
would be two entries 4587 and 4588.

Thank you.

 

[Gerald Stanley]

SELECT DISTINCT [Job Number]
etc

Hope This Helps
Gerald Stanley MCSD