Query to multiply two tables values against each other

[Ryan5896]

Hello, I setup a simple query in attached to multiply the twelve months values stored in table "tbl_005_FTE_Stat_Allocation" against the percent in table "tbl_004_FTE_Stat_GLStringMap" using the PRO Rata % record that sums to 100%. I can not seem to figure out why the query is not running and tying out between the original source and the new table made?

Original source data in table "tbl_005_FTE_Stat_Allocation" sums to 20,646, and when I run the query, the table output into "tbl_102_FTE_Forecast" only totals to 20,450.58, so a chunk is getting cut off somewhere/somehow but can not figure it out. I have zipped the DB and attached for reference. Any help is appreciated!

Thank you

[Welshgasman]

Rounding errors?

[Ryan5896]

Great catch! I removed the Round from formula and it ties out now. Thank you!