Hai,


I have a Access MDB and a table "Customer"

Fields are like this...

Cust_type, Invo_Number, Cust_number

The data in the table is like this....

3,1010001987,1000006
4,1010001987,1000006
3,1010001988,1000007
4,1010001988,1000007

Now I want to select distinct Invo_number and all the other fields in that record.

This will look like this....
3,1010001987,1000006
3,1010001988,1000007

Can anybody tell me How do I accomplish this with a SQL Statement?



------------------
ganraj.