UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Multi-level Group By Error, Office 2002    
 
   
rabroersma
post Feb 23 2011, 05:51 PM
Post #1

UtterAccess VIP
Posts: 1,215
From: Arcadia, California, USA
I have a report that I'm trying to create that has 4 report group by(s), but I keep getting the above mentioned error.

If I remove all of the report group by(s) from the report the error goes away.

Any thought?
Go to the top of the page
 
+
swgeof
post Feb 23 2011, 09:53 PM
Post #2

UtterAccess Addict
Posts: 209
From: Dallas, Texas
Never seen that error before, can you post a picture of your report in design view with the group by details?
Go to the top of the page
 
+
rabroersma
post Feb 24 2011, 12:02 PM
Post #3

UtterAccess VIP
Posts: 1,215
From: Arcadia, California, USA
I see what was causing the problem,

The underlying query was coalescing two correlated sub-queries.

So, Basically the report doesn't like:

CODE
SELECT NZ( ( SELECT ... ), ( SELECT ... )) AS result_column, ...


when report group-by(s) are applied.
Go to the top of the page
 
+
« Next Oldest · Access Reports · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 24th May 2013 - 11:32 AM