:disgust; I need to display the results of a query. The query runs properly. My
problem is having specific results display in specific locations in the
cfoutput table for the query. See attached code. This is what I get: 2005
Program Objectives Table # Objective Q1 Q2 Q3 Q4 (header row)
2 Obj. #2 q2 q3 3 Obj. #3 q2 q4 I need the results to line
up in the table like this: 2005 Program Objectives Table # Objective Q1
Q2 Q3 Q4 (header row) 2 Obj. #2 q2 q3 3 Obj. #3
q2 q4 Thanks for any assistance!

This is the query:
<CFQUERY name="q_rpt" datasource="#request.DPCds#"
cachedwithin="#createtimespan(0,0,2,0)#">
SELECT DPCRptr.*, DPCStatRptRptr.*, DPCStatRpt.*, DPCStatRpt.fk_Obj_ID as
Stat_Rpt,

DPCObjText.*, DPCObj.*
FROM DPCRptr, DPCStatRptRptr, DPCStatRpt, DPCObjText, DPCObj
WHERE DPCRptr.Rptr_ID = DPCStatRptRptr.fk_Rptr_ID
and DPCStatRptRptr.fk_StatRpt_ID = DPCStatRpt.StatRpt_ID
and DPCStatRpt.fk_Obj_ID = DPCObjText.fk_Obj_ID
and DPCObjText.fk_Obj_ID = DPCObj.Obj_ID
and DPCObj.fk_ObjType_code = #URL.ObjType#
ORDER BY DPCObjText.fk_Obj_ID, StatRpt_qrtr, created
</CFQUERY>

This is the display code for the query results:
<cfoutput query="q_rpt" group="fk_Obj_ID">
<tr><td>#fk_Obj_ID#</td><td>#ObjText_text#</td>
<cfoutput><td>#StatRpt_qrtr#</td></cfoutput>
</tr>
</cfoutput>