RE: MI Making a unique list

[Doug]

for returning unique numbers u need to use a GROUP BY expression.  So say your site numbers = field name SITEID:   select siteid from mytable group by siteid   this will return a single column in a query table to use to heart's content in dialogs etc.! regards doug   -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of galmala Sent: 24 August 2000 07:01 To: [EMAIL PROTECTED] Subject: MI Making a unique list Hey guys,   Here is an easy one for you - I have a field of site numbers - which unfortunatley are not unique. What I would like to do is querry this field and produce a second table that contains a list of each site number occurence. I am very new to SQL, but I think that this should be a simple query!!   Thanks in advance, Chris