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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Running Total in Crosstab Query
I figured it out - I created two queries - a select query and a crosstab query. I use the select query as the view for the crosstab query. Here is the select query (I named it qryRunningTotals): SELECT [Year Due] & IIf(Len([Month Due])=1,"0" & [Month Due],[Month Due]) AS DateKey...- puttygutt
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Running Total in Crosstab Query
I'm trying to sum a series of transactions by month, then continue to run the total from month to month. I created a regular select query with a sum statement: SELECT ARTRANS.[Artrans ID], ARTRANS.[Year Due], ARTRANS.[Month Due], ARTRANS.Customer, ARTRANS.Facility, ARTRANS.[Transaction Date]...- puttygutt
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
