What is I wanted to display the SUM of the Quantity along with the Customer... I simply tried this code:
dim sqlCommand sqlCommand = "" sqlCommand = sqlCommand + "SELECT SUM[Quantity], [supp-product], [Customer] " sqlCommand = sqlCommand + "FROM y2005m05 " sqlCommand = sqlCommand + "WHERE [supp-product]='VIT701380' AND [Customer]='B001K' " sqlCommand = sqlCommand + "GROUP BY [supp-product], [Customer] " objRs.open sqlCommand, objconn,1,3
However I get the following error...Error Type:Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)[Microsoft][ODBC SQL Server Driver]
Invalid column name 'SUM'./test_pro2/groupbysupp.asp, line 61