Query is too complex

[John_G]

I have found a partial solution for you. In your query Qry_SHLSMatrixDetails you are including fields from two earlier queries in the chain, Qry_RobustGrade and Qry_SHPOF. What I did was to include the fields LOF and FinalLOF from Qry_RobustGrade in all the queries following Qry_RobustGrade, up to Qry_SH-LS. I did the same for LS and RSR from Qry_SHPOF.

Now Qry_SHLSMatrixDetail has all the information it needs from the previous query, Qry_SH-LS, and it works just fine.



I haven't got qry-overallmatrixscore to run yet, but this is a start.

[seocavaz]

That's awesome, I will try that now. So, when I build queries, should I pull all the columns I need at the end throughout? I was in the mind set of keep them all as simple as possible then relink at the end. but if that works, then I may could get the overall one to work, because its basically comparing Qry_SH-LS and Qry-FPH-Asset to just figure out where in the matrix it should be.