How can I tally duplicate values (tally names) within a table..

J

Ja

I import a list of records and wish to tally the number of occurrences for
each imported name...I believe there is a way to collapse all of the
duplicate entries and tally them.
In other words I import a large number of items and wish to see a breakout
report of each item and the number of instances????

Any assistance would be much appreciated.
 
P

Phil

Put the Name field on the query grid twice. Hit the SUM button to make
it a summing query.
For the first field, set the totals box to "GOUP BY", and sort ascending.
For the Second field, set totals to COUNT.
 
6

'69 Camaro

Hi.
I import a large number of items and wish to see a breakout
report of each item and the number of instances?
Click to expand...

Try:

SELECT ItemName, COUNT(ItemName) AS NumItems
FROM MyTable
GROUP BY ItemName;

.. . . where ItemName is the name of your field, NumItems is the number of
occurrences, and MyTable is the name of the table.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info.
 
Top