Help with crosstab query

[Jason]

I have data from a query which is similar to below:

Client Brand Value
X Company Colgate $1,000
X Company Colgate $2,000
Y Company Colgate $5,000
Y Company Crest $3,000
Y Company Palmolive $7,000
Y Company Palmolive $9,000

I am trying to set up a crosstab based off of this query
which will give me the sum of the value amount for each
brand as follows:

Brand Value
Colgate $8,000
Crest $3,000
Palmolive $16,000

I have tried the following crosstab setup and have gotten
part way there, but am having a few problems. Here are
the parameters for my crosstab query:

Filed: fld_Brand fld_Brand fld_value fld_value
Table: qry_query qry_query qry_query qry_query
Total: Group By Group By Sum Sum
Crosstab: Row Head. Column Head. Value Row Head.


However, the result of this query gives me the following:

Brand SumOfValue Crest Colgate Palmolive
Crest $3,000 $3,000
Colgate $8,000 $8,000
Palmolive $16,000 $16,000


How can I change my crosstab query setup so that it only
givem me the first two columns of data (Brand &
SumOfValue)? Any help would be appreciated. Thanks.

Jason