Combined reports

  • Thread starter Thread starter Phil
  • Start date Start date
P

Phil

Hi,

I have three tables, a main table with names, a
transaction table, and an event table. The transaction
and event tables have a many to one relation with the main
table. I currently have filtered reports (selected by
name and using a key in the main table) for transactions
and events. One report for each. Is there a way to have
a combined report which would first list the transactions
and then the events? I would like to have one command
button which for the selected name would list all activity
for that person.

Thanks,
Phil
 
Phil said:
Hi,

I have three tables, a main table with names, a
transaction table, and an event table. The transaction
and event tables have a many to one relation with the main
table. I currently have filtered reports (selected by
name and using a key in the main table) for transactions
and events. One report for each. Is there a way to have
a combined report which would first list the transactions
and then the events? I would like to have one command
button which for the selected name would list all activity
for that person.
Click to expand...

Easy enough... embed the Reports you have into Subreports into a single main
Report.

Larry Linson
Microsoft Access MVP
 
Back
Top