Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Crosstab Query and where
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...- JoeMo
- Post #12
- Forum: Microsoft: Access Queries and JET SQL
-
Crosstab Query and where
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 =...- JoeMo
- Post #9
- Forum: Microsoft: Access Queries and JET SQL
