-
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.
-
...
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]
