Hello please help me to calculate this one:
I have a table containing this fields (name, project done, hours consumed)
example:
this is a table of a timesheet
[LIST=1]
[*]---------------------------------------------------------------------------
[*]| NAME | PROJECT DONE | HOURS CONSUMED |
[*]--------------------------------------------------------------------------
[*]| A | 1 | 5 |
[*]| B | 2 | 10 |
[*]| B | 3 | 12 |
[*]| A | 2 | 8 |
[*]| D | 1 | 9 |
[*]| D | 3 | 3 |
[*]| A | 4 | 6 |[/LIST]
my problem is how to get the total no. of hours of only "A'" or only "B"
for example: I want to get the total hours of "A"
5+8+6=19 hours then multiply it to 10 so that I can get the total salary of "A" which is 10X19=190
then the 190 should appear to the textbox of "A"
example:
A's Salary is : [190] <--- this is a text box inside a form
...
Please help me please
I'm using Access 2003
THANKS and GODBLESS