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?
Dustin - 15 Jan 2008 20:42 GMT
I figured it out.
Thanks though
> 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?