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.

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.







Ja wrote:

> 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.

Hi.

> I import a large number of items and wish to see a breakout
> report of each item and the number of instances?

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/ex...ributors2.html for contact info.


"Ja" wrote:

> 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.