dhookom: When a subquery acts on the same table as the main part of the query, I see no other way besides using an alias at least for the subquery portion. I chose to use aliases both in the main portion as well as the subquery for brevity's sake; retaining the table's full name for the main...
I have:
TRANSFORM Sum(nz(a.Credit)-(nz(a.Debit))) AS TotalThisMonth
SELECT Month(a.Date) & "/" & Year(a.Date) AS MonthYear
FROM AccountEntries AS a
WHERE ((Year([a].[Date])=2004) AND ((a.Property) Is Not Null)) AND ((Exists (Select b.ID, b.ParentID from AccountEntries as b where b.ParentID =...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.