I just converted this query from Access. Here's my SQL version:

SELECT	GETDATE() AS Snapshot_Date, 
		IM.IM_KEY,	-- AS Item, 
		
		CASE IM.IM_REV
			WHEN 'COMMON SET' THEN ''
			ELSE IM.IM_REV
		END AS IM_REV,

		IM.IM_KEY,		--AS [Item No Rev],
 
		CASE 
			WHEN LEN(LTRIM(RTRIM(RQ.RQ_MOSJOB))) > 0 THEN 'Work Order'
            ELSE 
				CASE 
					WHEN LEN(LTRIM(RTRIM(RQ.RQ_MOCNUMBER))) > 0 THEN 'Customer Order' 
					ELSE 'Other' 
				END
			END AS Reqt_Type,


		CASE WHEN LEN(LTRIM(RTRIM(RQ.RQ_MOSJOB))) > 0 THEN LTRIM(RTRIM(RQ.RQ_MOSJOB))
			 ELSE
				CASE 
					WHEN LEN(LTRIM(RTRIM(RQ.RQ_MOCNUMBER))) > 0 THEN RQ.RQ_MOCNUMBER 
					ELSE 'Other' 
				END
			END AS Reqt_Number,

		CASE 
			WHEN LEN(LTRIM(RTRIM(RQ.RQ_MOCNUMBER))) > 0 THEN RQ.RQ_MOCNUMBER
			ELSE NULL
		END AS Reqt_Line,
		
		RQ.RQ_DATE_REQ, -- AS [Reqt Date], 

		CASE 
			WHEN LEN(LTRIM(RTRIM(RQ.RQ_MOCNUMBER))) > 0 THEN RQ.RQ_DATE_PROM
			ELSE NULL
		END AS Reqt_Promise_Date,
		
		COUNT(RQ.RQ_OP_NUM) AS RQ_OP_NUM, --AS [Reqt Lines], 

		SUM(CASE 
				WHEN RQ.RQ_QTY_ISS > RQ.RQ_QTY_REQ THEN 0
				ELSE RQ.RQ_QTY_REQ-RQ.RQ_QTY_ISS
			END) AS Reqt_Qty

	FROM PK5.dbo.IM
	INNER JOIN PK5.dbo.RQ ON IM.IM_KEY = RQ.RQ_IMKEY

	WHERE RQ.RQ_MOSTYPE <> 'P' AND 
		  RQ.RQ_IM_STATUS = 'O' AND 
		  CASE 
			WHEN RQ.RQ_QTY_ISS > RQ.RQ_QTY_REQ THEN 0
			ELSE RQ.RQ_QTY_REQ - RQ.RQ_QTY_ISS
		  END > 0

When I run this I get:

Column 'PK5.dbo.IM.IM_KEY' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

Why can't I simply select out this (and other) column??? What if I don't want the data grouped?