Solved

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

Posted on 2013-02-06
3
472 Views
Last Modified: 2013-02-06
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    ###

etc.
etc.
etc.

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
0
Comment
Question by:IEHP1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
3 Comments
 

Author Comment

by:IEHP1
ID: 38860651
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?
0
 

Accepted Solution

by:
IEHP1 earned 0 total points
ID: 38860702
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
FROM (
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;
0
 

Author Closing Comment

by:IEHP1
ID: 38860922
got it!!
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

630 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question