Recent content by 072463

Hi Johpje, First of all thank you of the input. The query above can updated one accout type each time, but it add data on the top of the old data (see e.g 1 below), what I need is to generate a table with total hrs in different Account type in the same row under the same user name. In other word...

Sorry for the mismatch of the #s in the copy from a .txt format, e.g 4 should be in column Ttl_Util, 12 in Ttl_NonUtil and 18 is in Ttl_Util

Forget the post, I'm very sorry I posted to a wrong thread.

Help! I have 2 tables, I can manage to use 4 querys to put the data from table1 and caculate the sum of hrs and insert into the second table2(shown as below). Now the question is how I can rewrite the 4 query so it can updated the second table so that all the data is shown in one row that belong...

Help! I have 2 tables, I can manage to use 4 querys to put the data from table1 and caculate the sum of hrs and insert into the second table2(shown as below). Now the question is how I can rewrite the 4 query so it can updated the second table so that all the data is shown in one row that belong...

Help! I have 2 tables in MS Access database, if I want to do a calculation of total hrs in table1 for each user with different Account type as "Client, Util....etc and update to second table 2 with the table setting as follow Table 1: with 5 columns as follow User Client Project Account...