Making a report from 2 tables

[Emma]

Hi I'm not sure what to do I have a table called Address which stores
information about where the client lives and can add more addresses as the
client moves. I also have a main table. These two tables are only related by
client ID but not referentially. Now I would like to make a report sorted by
city (which comes from the Address table) then the clients names and intake
coordinator (which come from the main table). I'm not sure where to start?

 

[Beetle]

Create a query that returns the fields you need from both tables, then
use the query as the record source of your report. You can use Grouping
and Sorting in the report to get the data to display in your desired format.

 

[Emma]

Hi Sean,

It worked out well thanks!

Create a query that returns the fields you need from both tables, then
use the query as the record source of your report. You can use Grouping
and Sorting in the report to get the data to display in your desired format.