hi everyone. is it possible to union transform query?
SELECT * FROM (
TRANSFORM Sum(t0.TotCost) AS SumOfTotCost
SELECT t3.HierarchyLine+'.02' AS Hierarchy, t3.HierarchyMain, t3.HierarchyDetails, t0.LedgerDet, t1.ThisPeriod, t2.YTD
FROM (([Main Table] AS t0 LEFT JOIN (SELECT LedgerAcct...