eliminating duplicate values and summing up totals from query result.....HELP!

[fuecheefang]

Hello all,

Im stumped. I ran a query that returned multiple values (same). I need a way to only result in one name pulling up while adding the values for that person....? See below:

I basically want this table to have one name with the percentages totaled up together as a single row. Hopefully I make sense

FirstOfFirst Name	Last Name	Percentage
David	Aldridge	5
David	Aldridge	25
Carlton	Arrington	10
Carlton	Arrington	30
Carlton	Arrington	40
Ramkumar	Balasubramanian	40
John	Cronin	60
Terron	Curry	0
Ali	Drumwright	0
Ali	Drumwright	10
Ali	Drumwright	40
Sanford	Duitz
Sanford	Duitz	0
Sanford	Duitz	5
Sanford	Duitz	10
Sanford	Duitz	12
Sanford	Duitz	20
Sanford	Duitz	30

[June7]

Options:

1. aggregate GROUP BY (Totals) query - use the query builder

2. build report and use Sorting & Grouping features with aggregate calcs in group header/footer sections

This is all basic Access functionality.