Hiding duplicates in a Select Query 1

[jmc014]

Hi,

Sorry for asking this repeated question. I've gone over dozens of posts, but I cannot find a solution to my problem.


I've got a real simple query that is giving me duplicate info:

Id Contenedor
1 OOO123
2 PPP321
3 000123
4 PPP321

Here is an example of what I need from my query:

1 OOO123
2 PPP321


I'd like to hide, not delete, the duplicate information from my query, can anyone help before I get brain damage?
Here below is the SQL that I'm using:


SELECT Report_Bookins_IMO1.Id, Report_Bookins_IMO1.Contenedor
FROM Report_Bookins_IMO1;


Thanks for any assistance,

 

[dhookom]

How about

SELECT Min(Report_Bookins_IMO1.Id) as MinID, Report_Bookins_IMO1.Contenedor
FROM Report_Bookins_IMO1
GROUP BY Report_Bookins_IMO1.Contenedor;

Duane
Hook'D on Access
MS Access MVP

 

[jmc014]

What can I say other than thank you.