Copy data into specific records of table

[bsmith]

I'm trying to set up an expense database. So far I have a table where users enter hours worked each month for different project codes. Then I made a query to get different totals for each project code. So, now I have a table with results like this:<br>
<br>
Project Code TotalHrsforDeptA TotalHrsforDeptA<br>
A-1 100 100<br>
A-2 100 100<br>
<br>
Now I need to multiply these totals by a set currency value that the user will input and then insert them into a table that lists all of the project codes, like this:<br>
<br>
Project Code TotalHrsforDeptA TotalHrsforDeptA<br>
A-1 $1,500 $1,500<br>
A-2 $1,500 $1,500<br>
A-3 0 0<br>
A-4 0 0<br>
etc.<br>
<br>
But I can't seem to get the values into the correct records depending on project code. Any advice greatly appreciated!!<br>

 

[elizabeth]

Your question leaves out a lot of information needed to help answer. What is the structure of your table(s)? What are the relationships?