Showing number of duplicates along with single instances

[Muldoon]

I'm trying to make a very simple database for baseball / sports cards. In some of cases I have only a single card while other times I have duplicate cards. Below is a partial list of some of the cards:

Card	Year	Brand	Sport
1	1982	Topps	Baseball
2	1982	Topps	Baseball
3	1982	Topps	Baseball
4	1982	Topps	Baseball
5	1982	Topps	Baseball
6	1982	Topps	Baseball
6	1982	Topps	Baseball
7	1982	Topps	Baseball
8	1982	Topps	Baseball
9	1982	Topps	Baseball
10	1982	Topps	Baseball
10	1982	Topps	Baseball
11	1982	Topps	Baseball
11	1982	Topps	Baseball
11	1982	Topps	Baseball

I know how to create a Duplicate Query, but the output only shows the card if there are duplicates and does not include single instances.

Card Field	NumberOfDups	Year Field	Brand Field	Sport Field
6	2	1982	Topps	Baseball
10	2	1982	Topps	Baseball
11	3	1982	Topps	Baseball

What I would like is a query that will add all of the duplicate cards together to get a single total; something like the following:

Card	Total Number	Year	Brand	Sport
1	1	1982	Topps	Baseball
2	1	1982	Topps	Baseball
3	1	1982	Topps	Baseball
4	1	1982	Topps	Baseball
5	1	1982	Topps	Baseball
6	2	1982	Topps	Baseball
7	1	1982	Topps	Baseball
8	1	1982	Topps	Baseball
9	1	1982	Topps	Baseball
10	2	1982	Topps	Baseball
11	3	1982	Topps	Baseball

[June7]

Don't really understand the Duplicates query. A simple aggregate GROUP BY (Totals) query should show even singles.

SELECT Card, [Year], Brand, Sport, Count(Card) As CardCount FROM tablename GROUP BY Card, [Year], Brand, Sport;

[Muldoon]

Thanks. That is exactly what I needed!