Combining 4 reports into one

[richo]

I need to be able to combine several tables with a common key of a staff name to create a to do list. I have a company that deals with advertisers, distributors, printers and couriers. Several people in the company talk to 2 or more of these areas and then enter notes into the DB with a follow up date. I am able to create 4 separate to do lists and now wish to be able to combine all into one report. Please inform me how to?

Thanks in advance

Richard

 

[gwinn7]

One way is to create a master report with subreports for each list. The drawback to this is that the number of reports is static, unless you manually add more.

If its not static, then perhaps you can create a query to group the To Do lists based on each person. Or, you can set groupings in your report based on your original query.

Gary
gwinn7