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.
