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 ###
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:
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:
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
got it!!
ASKER