Grouping!?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ron - 13 Jul 2006 07:16 GMT

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

Reply to this Message

Allen Browne - 13 Jul 2006 07:34 GMT

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;

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> 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).

Reply to this Message