Grouping!?

R

Ron

Hi all,
I`m trying to craete a raw source for combo box from a table.
The problem is that the values shows more then once, I tried to do select
distinct but it didnt help, probably because of the ID(autonumber).

what to do?

TIA,
Ron
 
A

Allen Browne

So if there are duplicates, and you are trying to store the ID, which one do
you want?

Try a RowSource like this:
SELECT Min(ID) AS MinOfID, MyText
FROM MyTable
GROUP BY MyText;
 
Top