Query to group fields and sum

[rlsublime]

if I have the following amount other names in a table and I am trying to group them and sum them up. Curently i have figured out how to strip out the 3 names from the table but what i am trying to really do is group them as a BofA field with the sums of the 3.. how could i accomplish this?Thanks
Name 2010 2011 2012


BofA 1 22 44
Country Wide 55 66 88
Merrill Lynch 23 12 42

[June7]

Don't understand what you mean by 'group them as a BofA'.

Build a report to show detail records and summary totals of those records. Calculation in textbox of group or report footer can total each of the 3 columns.

[rlsublime]

I would like all totals to fall in a category called Bank of America. Is there a way to not do this through a report but to just add the sums in the fields. the reson is because there will be further analysis, ranking, pivots etc done in excel. so all the data will be exported and analyzed in excel. is there a way to sum the 3 records using a query.Thanks

[June7]

Are there other Names in this field? If not, just sum all the records. If there are other names, can include filter to retrieve only those that have any of the 3 names.

Does this get what you want:

SELECT "BofA" As [GroupName], Sum(2010) As Sum2010, Sum(2011) As Sum2011, Sum(2012) As Sum2012 FROM tablename GROUP BY "BofA" WHERE [Name]="BofA" Or [Name]="Country Wide" Or [Name]="Merrill Lynch";

[rlsublime]

Thanks. This looks like it could work. But I had two questions. 1) Where do i insert this statement and 2)Do I have to define a new field called group name. Currently I have the following fields: Name: 2010: 2011: 2012. Thanks

[June7]

Copy/paste that statement into the SQL View of query designer. Adjust it to use your table and field names. The query is constructing the GroupName field. It exists only within the query. Then switch to query Design View and can see the structure in the grid.