I am new to access and I do not know how to sum a row in table and multiple data from one table to another. The common fields between the two tables are period, year and dept.
for example:
Table 1
Period Year Dept Admin Expense Other add field to add across
08 2006 07333 2.00% 23.00% 56.00% 81.00%
08 2006 07222 23.00% 50.00% 27.00% 100.00%
09 2006 07333 60.00% 30.00% 10.00% 100.00%
09 2006 07222 30.00% 60.00% 10.00% 100.00%
10 2006 07333 10.00% 40.00% 40.00% 90.00%
Table 2
Period Year Dept category Amt add field where amt *admin add field where amt *expense add field where amt *other add field to add across
08 2006 07333 ab $450.00 ($450*2%) ($450*23%) ($450*30%)
08 2006 07222 dc $473.00 (10000.*23%)
09 2006 07333 ab $496.00
09 2006 07222 dc $519.00
10 2006 07333 cr $542.00
thank you,
for example:
Table 1
Period Year Dept Admin Expense Other add field to add across
08 2006 07333 2.00% 23.00% 56.00% 81.00%
08 2006 07222 23.00% 50.00% 27.00% 100.00%
09 2006 07333 60.00% 30.00% 10.00% 100.00%
09 2006 07222 30.00% 60.00% 10.00% 100.00%
10 2006 07333 10.00% 40.00% 40.00% 90.00%
Table 2
Period Year Dept category Amt add field where amt *admin add field where amt *expense add field where amt *other add field to add across
08 2006 07333 ab $450.00 ($450*2%) ($450*23%) ($450*30%)
08 2006 07222 dc $473.00 (10000.*23%)
09 2006 07333 ab $496.00
09 2006 07222 dc $519.00
10 2006 07333 cr $542.00
thank you,