Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Count Unique numbers
0 views
Skip to first unread message
Johnny
Jun 3, 2004, 11:52:42 AM6/3/04
to
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.
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
Jun 3, 2004, 12:08:16 PM6/3/04
to
SELECT DISTINCT [Job Number]
etc
etc
Hope This Helps
Gerald Stanley MCSD
>.
>
0 new messages