Printable View
what i need to do is select a part number from a database, and there may be more than one occurence of the part no., i have to count how many occurences and display the number of occurences and also display the part no. but i can't show duplicates, any clues?
Select * from table where partnumber='whatever'
.recordcount will tell you how many
rs("partnumber") will tell you the partnumber
but will that just return the unique number, there could be a few duplicates and i want to count them just not display them, and i have to return all the records, ummm
like this:
Part number 1 happens 4 times
Part number 2 happens 2 times
Part number 3 happens 3 times
sorta like that
select [partNo], count(*) from issuetable group by [partNo]