playagain 0 Newbie Poster

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.