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 MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How do I sum data by Month/Year using a crosstab query?
Thank you!!!- jose3106
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
How do I sum data by Month/Year using a crosstab query?
Below is the SQL code. It is currently formatted to sum the data by month. TRANSFORM Sum(Bookings.[Booking Amount]) AS [SumOfBooking Amount] SELECT Bookings.[National Account], Sum(Bookings.[Booking Amount]) AS [Total Of Booking Amount] FROM Bookings GROUP BY Bookings.[National Account] PIVOT...- jose3106
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
How do I sum data by Month/Year using a crosstab query?
I have a dataset that spans multiple years. I want to create a crosstab query that sums the data by Month/Year. When I run the query, the results are based on the actual date resulting in a crosstab query that has thousands of columns. Here is the desired output: 12/05 1/06...- jose3106
- Thread
- Replies: 4
- Forum: Microsoft: Access Queries and JET SQL
