Print range

[KevinS]

I have database of neighborhood contacts (Neighborhood Organizations),
which includes the neighborhoods leadership. Organization name and ID
are in one table (Neighborhood Organization), with leadership in
another table (Neighborhood Leadership).

I want to print a report that shows the leaders of a certain
neighborhood, not all listed in the leadership table.

How do I go about creating this report?

Thanks
Kevin

 

[Allen Browne]

I assume your Leadership table contains fields like this:
LeadershipID AutoNumber primary key
OrganizationID Number relates to a record in Organization
Surname Text
...

You will have created a one-to-many relation between the 2 tables, by
choosing Relationships on the Tools menu.

You can create a query, and add both tables. Drag the fields into the query
grid. In the Criteria row under the field from the neighborhood field,
enter:
[What neighborhood]
Test the query: it will pop up a box, where you can enter the neighborhood
you want.

Now create a report based on this query.