UtterAccess Discussion Forums > Multi-level Group By Error

Full Version: Multi-level Group By Error

UtterAccess Discussion Forums > Microsoft® Access > Access Reports

rabroersma

Feb 23 2011, 05:51 PM

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?

swgeof

Feb 23 2011, 09:53 PM

Never seen that error before, can you post a picture of your report in design view with the group by details?

rabroersma

Feb 24 2011, 12:02 PM

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.

This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.