• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 477
  • Last Modified:

Query is Too Complex Errror (Count Sections\Summary Report of Multi-Union Query)

So hey guys, thanks again for all the help on the Multi-Union query that I got going now.

I need now to be able to create a Summary report (count all the sections) like this:

Category                            Counts
Active Provider Sites         ###
Active Distinct Providers  ###
Active Distinct Vendors    ###


When I create a query off of the Aliased table I created for the Multi-Union query it gives me this error:
#2Query is Too Complex Error
  • 3
1 Solution
IEHP1Author Commented:
So I made separate Count queries for each section and the Counts all match, but how would I get the Categories as one column and the Counts as the second column?
IEHP1Author Commented:
OK so I plan to just keep Unioning off of this SQL structure I created:

SELECT ['Provider Network Snapshot Counts'].Category, ['Provider Network Snapshot Counts'].Counts
SELECT  "Active Provider Sites" AS Category, Count([Qry_Provider Network Active Sites Snapshot].Count) AS Counts
FROM [Qry_Provider Network Active Sites Snapshot])
AS ['Provider Network Snapshot Counts']
ORDER BY Category;
IEHP1Author Commented:
got it!!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now