Multiple Sources into One Report

[Mark K]

I have to gather input data for a report from seven sites. The data fields
from each site are all the same. I have successfully populated the database
using Oulook 2007 for each site and not successful linking a SharePoint site
to the database. Each site has its own table.

I have to summarize the data for the report by site, e.g., paragraph one has
a summary for each site, paragraph 2, meetings for each site, and paragraph 3
has a table with numeric data from each site that I need to sum. Something
like this:

1. Summary
a. Site 1. Data...(memo field)
b. Site 2. Data....(memo field)
2. Meetings
a. Site 1. Data...(memo field)
b. Site 2. Data....(memo field)
3. Server Usage table
Site Users HD_CAP (Gb)
1 8 200
2 4 150
Total 12 350

When I tried to create the query all the tables, Access reports there are
too many fields! Is there a way to create a query/report that I can export
to MS Word?

Thanks,
Mark

 

[Klatuu]

You can use a Union Query.

SELECT Site, Users, HD_CAP FROM SiteOneTable UNION SELECT Site, Users,
HD_CAP FROM SiteTwoTable UNION SELECT Site, Users, HD_CAP FROM
SiteThreeTable...

And so on.