ACCESS FEED: [MS_AccessPros] UNION query "Too Complex"

Sabtu, 29 Oktober 2011

[MS_AccessPros] UNION query "Too Complex"

I am using Access 2007 to prepare a statistical report from visits to
a web site.

I have planned a report with counts of visitors per folder. The query
that delivers the result is a UNION query and after I added the
latest folder count an error message was generated that the query was
"Too complex".

Here is the first part of the SQL:

SELECT "Bulletins" AS Visitors, TotalBulletins.SumOfVisitors
FROM TotalBulletins;

UNION SELECT "Conference Pages" AS Visitors, TotalConf.SumOfVisitors
FROM TotalConf;

UNION SELECT "Club Pages Combined" AS Visitors, TotalClub.SumOfVisitors
FROM TotalClub;

UNION SELECT "Clubs - Diamond Creek Pages" AS Visitors,
TotalDiamondCreek.SumOfVisitors
FROM TotalDiamondCreek;

Is there an Access limit to how many I may use?

Many thanks,

Robin Chapple