SQL return if for the column row there is only one number or many -- matching

[Bebe]

okay I have a column where for example say I have the number

100423 well I can have another 100423 it is not unique. How can I write code in SQL working in SQL that can do that.

What I am basically trying to do is if there is only one instance of a particular number. I want to get a count of all those, any ideas?

[Nina]

you should create your recordset with an SQLString, which only selects the columns that match the number your looking for

sqlString="SELECT * FROM table WHERE column=" & searchnumber

afterwards you can see with Recordset.Recordcount how many records you have

Hope this helps

[Bebe]

i dont' now the exact number i want to select any numbers that only have one entry. . .

Does this help or do i need help????

[JHausmann]

select key, count(key) from table group by key

change the word "key" in the above SQL to the item you want to count...

[BruceG]

You could add a HAVING clause to JHausmann's SQL statement. such as:
select key, count(key) from table group by key
HAVING count(key) = 1

[JHausmann]

I agree, I missed the part where he said he only wanted one entry...