Show All Even if Blank

  • Thread starter Thread starter Seahawk via AccessMonster.com
  • Start date Start date
S

Seahawk via AccessMonster.com

Got 5 Tables.
Table A is related to Table B,C,D and E.
The 4 underlying tables keep information related to date and time. Ex: Start
time of project goes into A. End time of the project will go into Table E.

Created a report were the name of the project-Table A- is soted ascending and
the times are listed below it for that day.

The problem is that when there is not a date, or record in one of the tables
for that day. The report will not show any of the records. Is there a way to
show all the records for that day, even if one of them has been missed? Ex:
Start time was placed in Table A, but Off project time was not placed in
Table C.
 
Hi,

Back in your query (with the five tables and various joins to table A.
Double click the join lines and you will see an option to include all rows
from Table A. This should overcome the situation you are experiencing.

I suspect your table structure should be looked at. Some normalisation would
probably help.

HTH

Terry
 
Back
Top