Duplicate query

  • Thread starter Thread starter juan
  • Start date Start date
J

juan

Hello,
I'm using MS 97 and have a table with two fields.
Material, Cust Material.
150DXX KAZZ-1
150DXX KZXX-2
1985ER ZZDR1

Is there a way to do a query that I can pick up no
Material Duplicate and Cust material.
Example.

150DXX KAZZ-1
1985ER ZZDR1

I don't care which Cust Material it picks up as long as
the Material doesn't show duplicates. If I do a group
query it will not do this, either with the find duplicates.

So please advise any info would be appreciated.
Thanks,

Juan
 
SELECT Material, First([Cust Material])
FROM MyTable
GROUP BY Material

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
 
Hello John,
I should have thought about that. Guess my mind today not
working right. Thanks alot for your help. really
appreciated.

Thanks again.
juan
-----Original Message-----
SELECT Material, First([Cust Material])
FROM MyTable
GROUP BY Material

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
Hello,
I'm using MS 97 and have a table with two fields.
Material, Cust Material.
150DXX KAZZ-1
150DXX KZXX-2
1985ER ZZDR1

Is there a way to do a query that I can pick up no
Material Duplicate and Cust material.
Example.

150DXX KAZZ-1
1985ER ZZDR1

I don't care which Cust Material it picks up as long as
the Material doesn't show duplicates. If I do a group
query it will not do this, either with the find duplicates.

So please advise any info would be appreciated.
Thanks,

Juan
Click to expand...


.
Click to expand...
 
Back
Top