how do i tell access to add up the totals for people with the same name?

[ilkvarr]

i have a table in access, that basically has fields
first name: lastname: cost: (is a few more things but not relevant)

each record, is the cost of a service. i want to be able to add up the total cost for each person, in either another table, or a query. does anyone know how to do this?

for example if there was

jo blogs £12
fred boon £10
jo blogs £5

i'd want a table with
jo blogs £17
fred boon £10


but i'd also want the orginal table.
if anyone can help me with this, would be most grateful

edit: oh, and if its helpful, i have a separate table with a list of all our customers.

 

[Smitty]

Welcome to the Board!

Add a Select query with Name/Cost of Service, then select Totals and Group By on Name and Sum on Cost.

HTH

 

[Joe4]

You would use a Totals (Aggregate Query) to do this.

Just add the three fields, firstname, lastname, and cost to your query.
Then click on the Totals icon in the toolbar of the Query Designer (looks like a Sigma).
This will add a "Totals" row under each field in the Query Designer.
Leave the firstname and lastname Totals fields set to "Group By", as these are the fields you want to Group on.
Then change the Totals field for cost to "SUM".
View the results.

This will SUM up each distinct grouping it finds.