I am sure there is an easy answer to this, but I am stumped!
I have a query pulling in these fields: Area, Heading, Year, IndustryGroup
(Year and IndustryGroup are not an issue as they are utilizing WHERE summaries)

I need the cfoutput to group by Area and Heading - BUT I want the Area to only
be displayed once, and then the Heading(s) to list beneath that.

I want it to look like this:

Foreign Trade Committee (this is an Area)

Committee Information (these are the Headings)
Communications
Meeting Minutes
Taiwan



But currently, this is what my query is doing

Foreign Trade Committee

Committee Information



Foreign Trade Committee

Communications



Foreign Trade Committee

Meeting Minutes



And so on..I am sure you get the idea. There are a number of areas that will
be listed with a number of Headings under each area.

Can anyone please help me with this? Below is the cfquery code in case this
helps.

Attach Code

SELECT IndustryGroup, "Year", Area, Heading
FROM tbl_industryarchives
WHERE "Year" = '#URL.Year#'
AND IndustryGroup = '#URL.Group#'
AND Area <> 'Activity'
GROUP BY Area, Heading, "Year", IndustryGroup
ORDER BY Area, Heading ASC