I have a product that has many different options. Ex. 12 rows 30 inch spacing
Red or 8 row 22 inch Spacing Green. I summarized the orders with this
statement in design view of the query. HeadDescription: [Rows]&"
"&[Spacing]&" "&[Color] . I used Group by to summarize them. But now I want
to see the totals of each summary in the next column. Ex. 12 30 Red 20.
How would I go about that?

I figured it out.

Thanks though

"Dustin" wrote:

> I have a product that has many different options. Ex. 12 rows 30 inch spacing
> Red or 8 row 22 inch Spacing Green. I summarized the orders with this
> statement in design view of the query. HeadDescription: [Rows]&"
> "&[Spacing]&" "&[Color] . I used Group by to summarize them. But now I want
> to see the totals of each summary in the next column. Ex. 12 30 Red 20.
> How would I go about that?