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?
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
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????
select key, count(key) from table group by key
change the word "key" in the above SQL to the item you want to count...
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
I agree, I missed the part where he said he only wanted one entry...