How do I combine Crosstab results into one row?

[Jaron]

Hi, I have a crosstab that converts the following:

Date	Name	Amount
5/1/12	Smith	5
5/2/12	Smith	3

into:

Name	5/1/12	5/2/12
Smith	5
Smith		3

Is there any way to get this instead:

Name	5/1/12	5/2/12
Smith	5	3

...by somehow combining the rows from the crosstab results?

Thanks for any help

[June7]

Try using the crosstab as source for an Aggregate GROUP BY (Totals) query.

[friendlyfriend]

It should do that automatically. That's what the "Group By" means in the "Crosstab" for the Name field. If not, it thinks the two Smiths are different. Does your query have any other fields? Are there possibly spaces (that you can't see) following some of the Smiths and not others? Can you provide the actual SQL?

[June7]

Doh! Good point friendlyfriend, I should have caught that. However, Access drops spaces at the end of string data in fields so maybe some other issue.

[Jaron]

Ok, thanks to both of you. I first did the aggregate query, which worked, then I saw the second response and changed the appropriate 'group by' to 'sum', which works good. Very simple.