ADO control

Hello all,

I have a project that I am working on that connects to a Database using an ADO control.

The database that it connects to has a table with the following fields:

Name, EarnedOrTaken, Hours, Date
eg Alice, E,23,10/4/00
Joe,E,25,10/25/00
Alice, T,20,11/00/00
Alice, E,4,11/12/00
where E stands for earned and T stands for Taken.

I want to create a summary for this report.

I want to know how I can say, have a combo box for the Names.
And when I select a name, I should get a summary of how much was earned nad how much was taken.

The form will have three fields:

Name(combo box), Earned, Taken

eg when I click Alice, I should get

NAme, Earned, Taken
Alice,27,20

Thank you.