ADO Project

Hello all,

I had a earlier thread on this project. I managed to do most of the things but I still have one issue outstanding and I would really appreciate some help.

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.

[Lafor]

Am not sure which db u're using..

send me the table (if Access) or

Export a sample of the table in a text file format
where the fields are separated by commas

table may contain three to 6 rows or more

will get back to u

send to: [email protected]