ok, let's see if i can explain this

[PJB]

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?

[Cander]

Select * from table where partnumber='whatever'

.recordcount will tell you how many

rs("partnumber") will tell you the partnumber

[PJB]

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

[sarath_777]

select [partNo], count(*) from issuetable group by [partNo]