Trying to avoid lots of empty space

[Romulus]

I currently have a main table with all person information such as name, id number, phone number, etc.

A given person belongs to one of 3 groups. I have set up tables containing relevant information that is specific to each of the 3 groups.

I have set up a query that brings some information from the main table and all information from the 3 group tables into this one query. I then based a form (for data entry purposes) and some reports on this query.

I hope I can describe this accurately.

What I have been given is a grid that has the person and within each person the different time periods going down and their related information and dates going across. I want to be able to generate reports that will look like this grid.

The problem is that for most of the time periods, dates and other information will not be filled in because they are not applicable for that time period, but the user wants to be able to see that. How can I set up my tables so the user can see the empty spaces but not have tables with lots of empty fields?

 

[TessB]

It's a join issue. When you join your tables establish the joins in this manner.

Show ALL records from Personal (Main table) and only records from Group 1 table in which ID number (or whatever your common keys are) are equal.

Hope that helps.