hkeric.wci
January 21, 2026, 5:19pm
3
There is an example BAQ attached:
[image]
Attached
TEAGLE-LastPartRevision.baq (31.6 KB)
You prob should maybe change the joins to Left Join so you could show blanks
[image]
Thats the method I linked you above in my previous post:
Basically if you have a Inner-Subquery but you do not use it in your Main-SubQuery how can use it in a Calculated field using the {InnerSubQueryName} syntax.
@tmcmullen you can also do Sub-Select SubQuery.
Then you wouldnt need to do GROUP BY on your Top-Query.
In a Nutshell:
Make a Sub-Query but DO NOT Use it on the Designer
On your TopLevel Query add the Sub-Query to a Calculated Field
On the Sub-Query under SubQuery Criteria you can add WHERE Clause.
Example:
SubQuery1:
[image]
[image]
SubQuery2:
[image]
[image]
Result:
[image]
[image]
Basically in a simpler view it does
SELECT (SELECT count(*) FROM table WHERe...) as YourCalculate…