Display the Contents of Two Tables in One Report

[Guest]

Hello,

I want to create a report that shows two lists. The first list will be a
list of projects and the second list will be a list of work codes. The two
lists are not connected and each have their own table that lists the projects
and work codes.

I tried to make a report that list all the projects with the control source
as the project table. This works find but when I added a subreport of the
work codes the list of work codes shows up for each project #, which is not
what I want.

In the end I just want a report that lists all the project names and another
list showing work codes.

Any idea how to do this?

Thanks in advance.

 

[fredg]

Hello,

I want to create a report that shows two lists. The first list will be a
list of projects and the second list will be a list of work codes. The two
lists are not connected and each have their own table that lists the projects
and work codes.

I tried to make a report that list all the projects with the control source
as the project table. This works find but when I added a subreport of the
work codes the list of work codes shows up for each project #, which is not
what I want.

In the end I just want a report that lists all the project names and another
list showing work codes.

Any idea how to do this?

Thanks in advance.

Create a report of just one table.
Create a report of just the second table.
Then add the second report to the first report as a sub-report.

 

[Guest]

Hi Fred,

I tried that but when I put the table two subform it created the second
table for every project so I ended up having each project # show the second
table when all I need is for a list that shows table 1 once and table 2 once.
For example:


Table 1 (main report) Table 2 (Sub report)
Project code Project name Work Code Work code name
701 Phase 1 10
Writing
702 Bio Assessment 11
Mapping
703 Fish Assesment 12
Data Analysis
704 Tree survey 13
Data entry


So basically when ever I had a project or work code to my table it will
update this summary report.

Thanks,