Generating Multiple MS Reports

  • Thread starter Thread starter michael_quackenbush
  • Start date Start date
M

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,
 
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.
Click to expand...


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.
 
Back
Top