Multiple Tables - One Report

[John J.]

I searched the site, but wasn't able to find an answer to the following. I have ten tables in a file, each representing a different facility. The fields in each table are identical. What I need to do is combine data from each table into a consolidated report, but cannot seem to accomplish this. I know I am missing something (please see attached), so it is time to call on the Pros...

Thanks,

John J.

[comment]

What good reason is there to keep the data in 10 different tables?

[John J.]

I actually have one table that contains all of the data, but I thought it might have been contributing to my problem so I was experimenting. Wouldn't I need to vary the repetitive fields for each program (i.e.; july crisis, july respite, etc.) if I want to use them in the same layout?

[comment]

I am afraid I don't quite follow. What exactly are these "repetitive fields" and what significance do they have?

Usually, when designing the structure of a database, we speak of entities and their attributes. It is sometimes difficult to decide when a collection of attributes justifies a new entity - but having identical fields (attributes) in each table, and the need for a consolidated report, are two strong indication that we are looking at a single entity (table).