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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
crosstab query help needed
WOW, That's perfect. THANKS!!!- hhhranch
- Post #8
- Forum: Microsoft: Access Queries and JET SQL
-
crosstab query help needed
I hope I'm doing this right. I am a novice. The original crosstab query was great except it gave me all cases completed. TRANSFORM Count(Intake2.Comp) AS CountOfComp SELECT Intake2.[T/N/D], Count(Intake2.Comp) AS [Total Completed] FROM Intake2 GROUP BY Intake2.[T/N/D] PIVOT Intake2.Opr...- hhhranch
- Post #6
- Forum: Microsoft: Access Queries and JET SQL
-
crosstab query help needed
Thank you for your replies. I want to say I mistyped when I posted. I did have the beginning bracket when I did the query. I was in a hurry when I posted the message and accidentally left it out. You guys are great in catching that. The actual error message was Microsoft Jet database engine...- hhhranch
- Post #4
- Forum: Microsoft: Access Queries and JET SQL
-
crosstab query help needed
I am new to Access (we use version 97). I have a crosstab query which gives me type of case (row heading) and opener (column heading). It gives me the count of those marked completed for each record in the table. What I'd like to do is narrow that to specify a date range (between..and..) I...- hhhranch
- Thread
- Replies: 7
- Forum: Microsoft: Access Queries and JET SQL
