REPORT USING TWO TABLES

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Domenick,

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

Geoff
 
Domenick said:
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.
Click to expand...

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 said:
Where is the option to add a sub-report? I think this is what I am looking for.
Click to expand...


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

Tom Lake
 
Back
Top