MI Making a unique list

[galmala]

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