I've been working on this project that works with a MS Access database. What I need to do with this and what I am having trouble with is I need to select a team name from a listbox and then calculate their total points.

I'm struggling to figure out how I can calculate this.

To help give you an idea of what I'm talking about the list is something like this:

control............... team

10.......................bilby

10...................... gumbles

20...................... bilby

20.......................gumbles

30.......................gumbles

(... = spaces)

So if i were to choose gumbles how do i just calculate all of the control points from the database giving me the result (from the example) 60.