Crosstab query - returning 1 record per week instead of 1 record

[JimStrand]

I have a crosstab query which is returning a new record for each column header instead of 1 row per Mode.Name

TRANSFORM Sum(WK_25_OT_Qry.SumOfEXPN_AMT) AS SumOfSumOfEXPN_AMT
SELECT Mode.ModeName
FROM CalendarPayroll_TY INNER JOIN ((WK_25_OT_Qry INNER JOIN SOF_Dept_Roll_Up_Tbl ON WK_25_OT_Qry.INDEX = SOF_Dept_Roll_Up_Tbl.INDEX) INNER JOIN Mode ON SOF_Dept_Roll_Up_Tbl.[Report Description] = Mode.ModeName) ON CalendarPayroll_TY.Description = WK_25_OT_Qry.INVOICE_DESCR
GROUP BY Mode.ModeName, WK_25_OT_Qry.INVOICE_DESCR, Mode.ReportSort
ORDER BY Mode.ReportSort
PIVOT CalendarPayroll_TY.Week_Ending;


I'm thinking it has to be something obvious that I changed but cannot see it. It should return only 1 line of data for each mode such as Bus Transportation but it is returning 1 line per each week up to the 25th week of the fiscal year (see attached) any thoughts on this obvious mistake would be appreciated. I'm back into the Access development game after several years off and could use some support. Thank you.

 

[JimStrand]

I figured it out. I had invoice description in one of the row headings and of course this is unique for each week. Thank you!