Need to display query results in specific locations inresults table

[JoyRose]

: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 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>

[JoyRose]

: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. 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>


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