Here is a simple BAQ that retruns the MAX(PartTran.TranDate) for each part and TranType
SubQuery1 (obviously it was completed after Subquery2 was made)
Subquery2 (it could have more tables and joins)
Subquery2 display fields. Note that all but the calculated field are “Group By”.
The expression for the calculated field is MAX(PartTran.TranDate)
Subquery1’s table relations
Subquery1’s display fields.
Note that none are group by.
And the results:
