PCMech Forums - View Single Post - ASP

mosquito · 01-16-2001, 02:01 PM

I think you want to do something like this.

Code:

strSQL = "SELECT Count(*) AS intRecords, TicketNumber, Rep"
strSQL = strSQL & "FROM tbl"
strSQL = strSQL & " WHERE Rep = " & Request.Form("Rep") & " "
strSQL = strSQL & "GROUP BY TicketNumber, Rep "

01-16-2001, 02:01 PM	#2
mosquito SQL nutcase Join Date: Sep 2000 Location: Belgium Posts: 1,136	I think you want to do something like this. Code: strSQL = "SELECT Count(*) AS intRecords, TicketNumber, Rep" strSQL = strSQL & "FROM tbl" strSQL = strSQL & " WHERE Rep = " & Request.Form("Rep") & " " strSQL = strSQL & "GROUP BY TicketNumber, Rep " __________________ Join The PCMech RC5 Team Today!