Comic Book Subscribers Database Query

[SueGrau]

I'm helping out a friend with a relational database to help him place comic book orders from his shop and to take subscriber lists from customers. I've done the following so far:

1. Created a Table of a master comic book list (there are hundreds) giving each comic book title a unique identifier number. Fields are ID#, Title, Publisher.
2. Created a Table of subscriber contact information giving each subscriber a two letter identifier code. Fields are ID, Last Name, First Name, E-mail, Phone number
3. Created a Table to enter subscriber information using the first two tables where you enter the Subscriber ID followed by the Comic Book ID based off of a subscriber sheet submitted by the customer. For example, my list contains 70 titles so there are 70 entries on this table for me. The first field is SG in this case and the second field the comic book ID number.

So far this works and I've created queries and reports that allow the owner to print out an individual's subscriber list for updating, master lists of comic titles by publisher, etc.

What I don't know how to do is to create a list of all the times a number appears in 3rd table under the comic ID field. For example, if 7 subscribers all get comic 32 (Avengers), 16 get comic 27 (Batman) and 2 get comic 121 (Aquaman). I want to be able to print out a report that says:



Aquaman 2
Avengers 7
Batman 16

So how do I get Access to count the number of times an ID number appears on a table?

Thanks!

Sue

[June7]

Can create an aggregate GROUP BY (Totals) query.

Or build a report that uses Grouping & Sorting features with aggregate calcs in group section header/footer. The report will allow display of detail records as well as summary totals.

Access Help has guidelines on both.