Generating Multiple MS Reports

[michael_quackenbush]

I have two tables in MS Access and would like to generate a master
report separated on individual pages for eahc user.

Table 1: PeopleID
Fields: NameID, Last Name, First Name

Table 2: Contributions
Fields: NameID, Date, Amount

I would like to be able to generate a report that would print a page
for each NameID so they can use for tax purposes that shows their
contributions to a fund.

Any help on writing this query and report would be helpful.

Thanks,

 

[Marshall Barton]

I have two tables in MS Access and would like to generate a master
report separated on individual pages for eahc user.

Table 1: PeopleID
Fields: NameID, Last Name, First Name

Table 2: Contributions
Fields: NameID, Date, Amount

I would like to be able to generate a report that would print a page
for each NameID so they can use for tax purposes that shows their
contributions to a fund.

Create a query that joins the two tables and use that as the
report's record source. Then use Sorting and Grouping (View
menu) in the report's design to create a group with header
section on the name field. Set the group header section's
ForceNewPage property to Before Section to start each name
on a new page.