I am new to Access and need some help here is my problem

I built my data base to track equipment inspections. There are about 75 tables each type of equipment has its own table with up to 100 different serial numbers for each piece of equipment. I need a report or a query I make to a report that will tell me the total number of records in each table and the total number inspected by quarter. I have been able to make 75 different reports one for each table but I would like to make one report for all of the tables. Can this be done???

How have your structured your tables?

There are about 75 tables each type of equipment has its own table with up to 100 different serial numbers for each piece of equipment. This is the wrong way to structure tables.

At first glance I would say you only need two tables. One table is for Equipment. The other table is for serial numbers. Using this structure you will easily be able to report either a single piece of equipment and its associated serial numbers or all equipment and associated numbers. You would only need to create one or two reports.

Do some research on Normalisation (Normalization). This is at the heart of good database design. If your design is good then creating queries and reports becomes much easier.

Chris

I was thinking much the same as stopher. That is why I asked how you had structured your tables.