Use different criteria for different columns?

[AccessTheBase]

I get this query result:

Product1 | Description | Sum of Sales | Japan
Product1 | Description | Sum of Sales | USA
Product1 | Description | Sum of Sales | Germany
Product2 | Description | Sum of Sales | Japan
Product2 | Description | Sum of Sales | USA
Product2 | Description | Sum of Sales | Germany



I want to get this query result

Product1 | Description | Sum of Sales in Japan | Japan | Sum of Sales in USA | USA | Sum of Sales in Germany | Germany
Product2 | Description | Sum of Sales in Japan | Japan | Sum of Sales in USA | USA | Sum of Sales in Germany | Germany

How can I achieve this?

[pbaldy]

First I'd play with the crosstab query wizard. It looks like what you want to do. Otherwise, you're looking at a function along these lines:

Return a concatenated list of sub-record values