REPORT USING TWO TABLES

[Domenick]

How can I write a report in Access using two (2) different tables. I
established "Relationships" between the two tables, but I cannot figure out
how to add a second table to a report and link it to the first table.

Thanks.

 

[Geoff]

Domenick,

Create a query that includes the two tables and make the query the
RecordSource for the report.

Geoff

 

[Tom Lake]

How can I write a report in Access using two (2) different tables. I
established "Relationships" between the two tables, but I cannot figure out
how to add a second table to a report and link it to the first table.

Thanks.

If it's a one-to-many relationship, add a subreport to the main report
and make the source of the subreport be the many table.

An example of a one-to-many relationship is customers and their orders.
One customer can have many orders but one order is only associated
with one customer.

Tom Lake

 

[Domenick]

Where is the option to add a sub-report? I think this is what I am looking for.

-Dom

 

[Tom Lake]

Where is the option to add a sub-report? I think this is what I am looking for.

It's one of the icons in the toolkit. Click on the toolkit icon to open it
and you'll see it

Tom Lake