Summing and subtotals

[dbfool]

What is the best way to sum? Here is my situation. Have a list of data (custlastname, sumofpurch, brand). I want to produce a list that shows by person how much they spent total and a subtotal of each brand that they spent with. Of the multitude of brands I offer, I am only interested in learning about the subtotals for about 6 of them and I could screen for each in separate columns. Optimally the result would look like this...

custlastname, sumofpurch (all brands), subtotal sumofpurch (brand1), subtotal sumofpurch (brand2), etc.

Any help is appreciated.

[pbaldy]

Play with the crosstab query wizard. Once you get the formatted result you want, you can add a criteria to restrict to the 6 brands.