How do you combine subform data with mainform data?

[John]

Hello,

I have simple project tracking database. The mainform is used to enter data
about each project for four company divisions. The subform is tracks tasks
for every project. However, each project may not have tasks.

How can I create a report which shows data for ALL projects including tasks
by division? When I combine these two, only those projects with tasks are
included (I assume because a record was created for the task). My report
keeps excluding projects with no tasks.

Main table is linked to related table (one-to-many) via ProjectID:

Main:
ProjectID - primary key
ProjectName
Division
etc.

Related Table:
TaskID - primary key
ProjectID
Task
etc

 

[Rick Brandt]

Hello,

I have simple project tracking database. The mainform is used to
enter data about each project for four company divisions. The
subform is tracks tasks for every project. However, each project may
not have tasks.

How can I create a report which shows data for ALL projects including
tasks by division? When I combine these two, only those projects with
tasks are included (I assume because a record was created for the
task). My report keeps excluding projects with no tasks.

Main table is linked to related table (one-to-many) via ProjectID:

Main:
ProjectID - primary key
ProjectName
Division
etc.

Related Table:
TaskID - primary key
ProjectID
Task
etc

Use an outer join in the query for the report. If you double-click the join
line and look at the choices it is pretty obvious which option to use.

 

[John]

Thanks Rick! I cannot believe how easy that was.

Use an outer join in the query for the report. If you double-click the join
line and look at the choices it is pretty obvious which option to use.