Seperate Tables Seperate Reports, Please make them one.

  • Thread starter Thread starter Andrew
  • Start date Start date
A

Andrew

I have a table named IDR Heading, and four individual tables that link by IDR
Heading Report Number (ID no duplicates to Number long integer Dupes OK) the
four tables can have several records relating to the IDR Heading, long
intiger is the IDR Heading ID Value). I have created a report with fields
from the IDR Heading and information from the four other tables. I want to
create a report that prints info from ONE IDR Heading and related data
(Linked to the other for tables that may have several records) and show all
the related data from the other four tables.

Every filter I have applied gives me the right combination but on seperate
reports
I've been working for days, Help.
 
Try creating a query that joins the five tables together, and use the query
as the recordsource for your report.

Alternatively, try adding the four reports based on the four other tables as
subreports on the report based on table IDR Heading.
 
Back
Top