Finding and counting (not records but entries)

[gpbanseo]

Hi all:


Appreciate any help you may be able offer. I have a table that contains inspection records. Table contains field "vendor_nr" which is a numeric 6 digit field. I need to be able count how many records each vendor_nr has. I have tried a query and using both SUM and COUNT but they both eiher total the vendor_nr or suchlike. In other words I would like the database to tell me how many instances of a vendor occur for reporting to management. Any ideas?
Thanks a Million

[jzwp11]

Welcome to the forum!

If I understand what you want, using an aggregate query with Count() should have given you what you needed, so I have to ask what did the query look like?


I would structure the query as follows:

SELECT vendor_nr, Count(vendor_nr) as CountForVendor
FROM yourtablename
GROUP BY vendor_nr

[gpbanseo]

Thanks a million - this worked perfect.

[jzwp11]

You're welcome; good luck with your database.